Click here for important information about Computing.net.
how do i delete only the first carriage return in a cell in Excel 2010
Hi Spaceling You can do this with a formula like this
=SUBSTITUTE(A1,CHAR(10)," ",1)
Where A1 contains the text.
| Yes (14) |  | |
| No (14) | | |
| I don't know (15) | |
Ad Choices