Text into Columns

[tcmh]

For some reason I cannot accomplish this function - I use the menu drop down
Text to Columns, I choose Delimited, Next, comma (although there are spaces
at the end of each line), General, Finish

What I get is a break out of only two lines turned into columns.

Thanks!

 

[Mike H]

Hi,

How many commas do you have in this delimited string? Can we see a sample of
the data?

Mike

 

[tcmh]

Below is an example data - there is one row between each



Agape Centre of Truth
Meeting at: 103 Republic St.
Newtown Kitty, Georgetown, Guyana
Mailing/Office Address: 103 Republic St.
Newtown Kitty, Georgetown
Guyana

 

[Dave Peterson]

There are only two lines that have commas in them.