Text into Columns
 

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!

Text into Columns
 

Hi,

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

Mike

"tcmh" wrote:

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!

Text into Columns
 

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


"Mike H" wrote:

Hi,

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

Mike

"tcmh" wrote:

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!

Text into Columns
 

There are only two lines that have commas in them.

tcmh wrote:

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

"Mike H" wrote:

Hi,

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

Mike

"tcmh" wrote:

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!



--

Dave Peterson