how do i delete only the first carriage return in a cell in Excel 2010

Hi SpacelingYou can do this with a formula like this=SUBSTITUTE(A1,CHAR(10)," ",1)Where A1 contains the text.

You can do this with a formula like this

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

Where A1 contains the text.