Excell additonal formating option (web query)

  • Thread starter tatiana.pacheco
  • Start date
T

tatiana.pacheco

I am importing a table to a excell spreadsheet. One of the rows is like
this:

HSBC Mtg v Robinson, Mary Ann & Douglas; 1206 Sheridan Av N, Mpls,
55411 22117065

How can I do for this line to become a column after every comma.I will
need a column for every information in between the commas. Could
anybody help me to solve this?
 
J

John Nurick

Hi Tatiana,

This newsgroup is for questions about handling external data with
Microsoft Access database software. It seems that you are using Excel.

If so, I believe that Excel's Text to Columns command (on the Data menu)
will do what you want. If it doesn't, ask your question in an Excel
forum.
 
Top