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

J

Joe

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
 
P

Peo Sjoblom

in the find what box hold down Alt and type 010 on the numpad, release Alt,
replace with space or nothing
 

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

Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Global Template Network and saving auto texts & macros 2
Merging from an Excel file with graphics 1
Calculate the median value before a specified list 0
Vlookup and return sheet name also 2
Place picture in Excel cell 0
Finding the height of a row in a word table from Excel 0
How can I print rows that go outside of the page without shrinking the text? 0

Top