clean up data

[BNT1 via OfficeKB.com]

Hi

Have seen this somewhere, but now cant find it

I have a spreadsheet and each cell comes with various things like ^ and the
letter "Y" with a squiggle on top, etc after the actual data required

Can you point me in the right direction to clean this sheet up

Thanks in advance

regards

 

[Joel]

Easiest way is to use the replace command under edit.

You can replace ^ with nothing to remove the character