Replace in a formula? {El Resolved-ed}

Hey all, I know how to use Replace() in code of course, but is there a formula you could use to do the same thing as: Replace(ActiveCell.Value, Chr(10), "") ?

I was checking out the =Replace() Formula but it doesn't seem to work the same.

Thanks.

That's because you want to use:

=SUBSTITUTE($A$1,CHAR(10),"")


;)



zaza

Just what I needed, thanks!