Splitting a column - Not recognizing data

L

LaurieAZ

I'm trying to split a column of data into multiple columns (using Excel
2007). I've followed the process to split the data, but Excel is only
recognizing the first line of data, when there are 3-4 in each cell. Here's
what a cell looks like:

"Mr. Gregory J. XXXX
Northwestern Mutual Financial Network
4647 N. 32nd St., Suite B105
Phoenix, AZ 85018 "

I imported the data (about 1500 records) into Excel from a database that
gave me very few options in terms of formatting the output. It appears that
there is a "hard return" between each line of data. My question is: how do
I get Excel to recognize the hard return as a delimiter?

Thanks!
 

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

Chart is recognizing "" data as 0 1
Cell not calculating after importing data 2
Splitting Text from single cell in column across multiple Columns 3
Splitting cells in Excel 2007 2
Splitting data in a cell 2
Replace hard return with a delimiter? 3
Convert a column of data from Text to date format 2
Auto splitting of data in a cell 1

Top