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.