Delimiting a Cell

[MCisyS2014]

I have a spreadsheet that has 1794 rows and one column (B). Each cell has the following format (see below):




" Crowley & McKoon
Attorneys
2420 Double Churches Road
Columbus, GA 31901-
(706) 324-4375
[email protected]"




Again, this information is in cell B1. The next cell with data is cell B3 (see below)


"100 Black Men of W. GA.
Community/Civic Organizations & Non-Profits
601 Union St.
LaGrange, GA 30241
(706) 812-1007
[email protected]"



I am trying to get each line of the information into its' own cell. How do I delimit the entire spreadsheet or do I have to do each cell independently?

[Ron Coderre]

Try this....
• Select your single-column list
• Data.Text-to-columns...Check: Delimited...Click: Next
...Check: Other....in the character box: Hold down CTRL and type J
...Click: Finish
Is that something you can work with?

Note: I corrected the above...Data.Text-to-columns was incorrectly entered as: Home.text etc

[MickG]

Even Better !!!

[MCisyS2014]

Gentlemen:

No, this did not work as when I selected the delimited and clicked next, the box only showed the Name at the top and all the other data in the box was gone??? Any other suggestions?

[Ron Coderre]

I think you'll need to post a sample workbook so we can figure out what's happening.

[Xx7]

Hello, Click the "Parsed" button on the attached, then check "Sheet2" for the output.

Please Login or Register  to view this content.