ExcelBanter - move a special character

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

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

- - move a special character (https://www.excelbanter.com/excel-programming/338984-re-move-special-character.html)

Mike Q.

move a special character

=clean(A1)
Drag formula down as far as nessary
Then Copy & PasteValue to a new spreadsheet
--
Mike Q.

"Mark" wrote:

Hi,
Anyone knows how to move a small
rectangle character out from excel cell.
Please see attached file, real file contains
more than 8000 records.
Thanks,

--
Mark

All times are GMT +1. The time now is 07:09 PM.