Removing "line feeds" from text within a cell.

J

John Toole

I am using MS Excel 2003 SP2. I have a column for street address. Some of the 20,000 people entered the data on multiple lines within the cell instead of one single line delimited with the ; character as requested. Not really sure how they did that.

When I export the data to csv format I need the address to be on one line. I cannot determine how to replace the special character that represents the line feed with the ; character. Any ideas?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
S

Susan Ramlet

Hi, John,

This is a line feed or carriage return character. Usually people use "Alt +
Enter" to create it. If you're looking for it to be done programmatically,
David McRitchie has an explanation here which may be of some help:

http://www.mvps.org/dmcritchie/excel/crlf.htm

If you want to do it manually, do this:

Go to Edit | Replace. In "Find what", hold down Alt and type 010 on the
number pad. Release the Alt key. In "Replace with", type in your
semi-colon. Select "Replace All". Repeat the same steps using Alt+013.
 

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

Cant type on line E31. 4
delete links from the resource view in Project webaccess 2003 1
removing line feeds from text files 3
Removing various combinations of text and returning only a number inexcel 6
How can I customize the Project ID field? 3
Drawing a line across a page 1
new line within a cell 2
MS Access 2003 - Query ? 0

Top