Articles

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

December 19, 2012 at 14:27:12
Specs: Windows 7 Pro

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

See More: how do i delete only the first carriage return in a cell in

Report •


#1
December 19, 2012 at 15:04:49

Hi Spaceling

You can do this with a formula like this

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

Where A1 contains the text.


Report •
Related Solutions


Ask Question