Text into Columns

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!
 
M

Mike H

Hi,

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

Mike
 
T

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
 

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

How to center adjust text above and image in a two column document. 1
Two columns followed by single page-width column on same page 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
MS Project Center-Autolink column fields 0
Select Text to End of Footnote 9
Improving Macro That Keeps First Letter 0
Delimiters in Text to Columns 0
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top