Removing specific characters from a cell?

[Mr2017]

Hi

I've got dozens of cells where I need to remove the apostrophe and the '-' in the cell in order to make the data compatible with another system.

Eg if the cell A1 had the text

Goodfella's Greatest-Ever

I'd want to use a formula in B1 that removes the apostrophe and the dash.

Does anyone know how to do this, please?

 

[Tom.Jones]

Did you try SUBSTITUTE function?

 

[Special-K99]

Try

=SUBSTITUE(SUBSTITUTE(A1,"'",""),"-","")

 

[Mr2017]

Hi Tom

No, I hadn't, as I'm not sure how to use it in this case?

 

[Mr2017]

Hi Special K-99

Thanks for posting that solution.

When I tried it, however, I got a "#NAME?" error?

 

[Joe4]

Hi Special K-99

Thanks for posting that solution.

When I tried it, however, I got a "#NAME?" error?

He has a typo. The first word should be SUBSTITUTE, not SUBSTITUE.

 

[sandy666]

=SUBSTITUE(SUBSTITUTE(A1,"'",""),"-","")

red should be SUBSTITUTE

edit:

too late

 

[Mr2017]

Ok, thanks Joe - it works now.

 

[Mr2017]

Thanks Special K-99 - it worked after adding the T before the E and after the U in the first 'Substitute' word.

Thanks again for posting this.

 

[Special-K99]

I type too quick