Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I strip a new line /nl in a cell in Excel globally
I receive a spreadsheet from a client that contains new lines (carrige
returns) within a cell. I would like to strip the returns and make it one line, globally. I'm thinking that there may be a way to do it using find/replace but am not sure. Any help would be appreciated. Thanks |
#2
|
|||
|
|||
in the find what box hold down Alt and type 010 on the numpad, release Alt,
replace with space or nothing -- Regards, Peo Sjoblom "Joe" wrote in message ... I receive a spreadsheet from a client that contains new lines (carrige returns) within a cell. I would like to strip the returns and make it one line, globally. I'm thinking that there may be a way to do it using find/replace but am not sure. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel tab key to move to right adjacent cell | Excel Discussion (Misc queries) | |||
I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions |