How to remove Apostrophe in excel

Closed
layhui
Posts
1
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
- Sep 24, 2015 at 10:16 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Sep 25, 2015 at 08:28 AM
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

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Sep 25, 2015 at 08:28 AM
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.
0