ExcelBanter - Find & Replace ~

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find & Replace ~ (https://www.excelbanter.com/excel-programming/310264-find-replace-%7E.html)

Mark

Find & Replace ~

I am using Excel 97.

I have a worksheet which has the ~ character in quite a lot of cells which I
want to delete.

Find & Replace will not pick it up.

Can anyone assist with some code, please?

Thanks

--
Mark

Rob

Find & Replace ~

Mark,

Use Find and Replace but enter TWO ~~, this will do the job.

Rob
"Mark" wrote in message
...
I am using Excel 97.

I have a worksheet which has the ~ character in quite a lot of cells which
I
want to delete.

Find & Replace will not pick it up.

Can anyone assist with some code, please?

Thanks

--
Mark

All times are GMT +1. The time now is 02:24 AM.