Excell additonal formating option (web query)

  • Thread starter Thread starter tatiana.pacheco
  • Start date 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?
 
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.
 
Back
Top