Text into Columns

  • Thread starter Thread starter tcmh
  • Start date Start date
T

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!
 
Hi,

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

Mike
 
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
 
Back
Top