Remove Apostrophe from text...

If there a function (no vba) that can remove an apostrophe from a text string.

For example :-

Leader's Choice ----- Leaders Choice

PRINCE CHARMIN' ------ PRINCE CHARMIN

RUN DON'T HIDE --------- RUN DONT HIDE

etc.

Select desired range and Ctrl + H

Replace ' with (Nothing)

You could use find and replace. But if that's not suitable, assuming your data starts in A1, past this into B1 and copy down. Note there is an apostrophe between the first set of double quotes.

Formula:

Please Login or Register  to view this content.

BSB