Maybe it's not an alt-enter.

I'd try this next:
=SUBSTITUTE(A1,CHAR(13),"")

If that doesn't work...

Chip Pearson has a very nice addin that will help determine what that
character(s) is:
http://www.cpearson.com/excel/CellView.htm

Then you can use that info in the correct formula.


salvo00 wrote:

Thank you Bob.
The formula replaces the line-break with a small square.
I don't want that symbol. I just want a space and all the text in 1 line.
Is there a solution?
Salvo

"Bob Phillips" wrote:

=SUBSTITUTE(A1,CHAR(10),"")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"salvo00" wrote in message
...
How can I remove the "ALT+ENTER - line break" from a list of cells ?




--

Dave Peterson