If you wanted to get rid of all the alt-enters in a range, you could:

Select the range to fix.
Edit|replace
what: type ctrl-j
with: (space character or leave blank???)
replace all

If you needed a macro, you could record one while you did it manually.

Darin Kramer wrote:

Howdie,

I have a column on which the first line of each cell is the "alt enter"
symbol (ie detail starts on second line within a cell). How do I find
that alt enter charachter and replae it with nothing (ie moving the
second line of text up to the first line of text) within each cell?

Regards
D

*** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson