Hi
why not use 'Edit - Replace' for this. In the search box hold down the
ALT key and enter 0010

--
Regards
Frank Kabel
Frankfurt, Germany


Simon Shaw wrote:
I have a spreadsheet that contains cells where I used Alt + Enter to
soft-return within a Cell so information would appear on two lines.
However, the spreadsheet needs to be saved as a Tab delimited Text
file. This Alt + Enter causes a carrige return character in the text
file which causes me problems.

I want to write a quick macro to search the cells in the spreadsheet
and replace the Alt + Enter character with a space. is there a
character number for the Alt + Enter?