Excel Excel 2007

Joined
Mar 4, 2011
Messages
1
Reaction score
0
I have a text file created by a client that contains names and addresses that I need to get into an excel file. Unfortunately when a string of data contains two address fields they are separated with a carriage return. So when I import as coma separated values when ever there are two address fields it breaks the string into two lines. Any help would be appreciated.

Mike
 
The "concatinate" function can join stings together into one cell.
 

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


Back
Top