32 is a space isn't it, probably not a good idea to remove that.

Also, in case you don't know, you can embed the subs

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

--

HTH

Bob Phillips

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

"salvo00" wrote in message
...
I found out that there are several characters codes: 10, 13, 32
Doing =SUBSTITUTE with all characters (i have found) solves the problem.
I am not sure yet but I am testing it ..
Thanks very much for all your help.


"Bob Phillips" wrote:

Do a =CODE(MID(A1,4,1))

to get the character code (change 4 to where it actually is)

--

HTH

Bob Phillips

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

"salvo00" wrote in message
...
Thanks.
Unfortunately it is not an alt+enter.
After testing both char(10 or 13) I always get at the end of the
phrase a
small square (cube).
The cells have been exported from the MS-Access.
In each cell there were 3,4 phrases. I'm trying to get a non-formatted
text
(no line breaks) but it seems impossible.
Salvo



"Dave Peterson" wrote:

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