Excel file with special character with data

[Jagdev Singh]

Hi Experts
I have received an excel file in which there is “ ‘ “ used in front of the data. Is there any excel way to remove it from throughout the sheet.
Regards,
JD

 

[Pavan.Sada.PS]

Hello JD,

In a blank cell type 1 and copy that cell and select all the cells which has this special character and do a past special with multiply operator. I hope this should help you to get rid of those special character

Regards,
Pavan S

 

[Syedali]

Hello JD,

In a blank cell type 1 and copy that cell and select all the cells which has this special character and do a past special with multiply operator. I hope this should help you to get rid of those special character

Regards,
Pavan S

Copy and paste special as a values in fresh sheet. It will automatically disappear.

 

[Jagdev Singh]

Hi Syed and Pavan

Both the option worked like a charm!

Thanks
JD

 

[Deepak]

Hi,

"'" was used to store numbers as text.

 

[Jagdev Singh]

Hi Deepak

Thanks for sharing your view on it.

Regards,
JD