How can I strip a new line /nl in a cell in Excel globally

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
in the find what box hold down Alt and type 010 on the numpad, release Alt,
replace with space or nothing
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I delete the first 3 characters of each cell, all differe. 4
Vlookup and return sheet name also 2
Stripping out imbedded spaces in a cell/row 8
Remove e-mail address from general text field. 2
XmlSerializer replacing cr+nl with nl when loading 6
How to get range names to Apply across multiple tabs 1
CHAR(10) does not create new line in excel 2007 4
How do I ignore cell values of zero? 2

Back
Top