How to remove Apostrophe in excel

Closed
Report
Posts
1
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
How to remove Apostrohe in excel eg. '6018-8400-1532-3636 to 6018840015323636.

I successfully remove the dashes by using "Find & Replace" but can't remove '.

Kindly please assist how to done it.

I try to using function such as copy & paste but unsuccessful.

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
layhui, Good morning.

After you remove dash from that cell, probably all the content was left-aligned.
I suppose the signal apostrophe stays in a content.

When this happen, a RED triangle appears at left indicating that there is a error at this cell.

If you click on it, will appears a message that there is a NUMBER with text format at that cell.
Appears a option to "Convert this to number".
Try to choose this one.

If after it a number is converted to Scientific format don't worry about it.
Format Menu and choose NUMBER.

Please tell us if it worked for you.