ExcelBanter - clean up data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - clean up data (https://www.excelbanter.com/excel-discussion-misc-queries/130651-clean-up-data.html)

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

Easiest way is to use the replace command under edit.

You can replace ^ with nothing to remove the character

"BNT1 via OfficeKB.com" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1