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

Tags:
DELETE
excel 2010
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 •
Start a discussion
Related Solutions
See More ↓


Ask Question