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.
 
You must log in or register to reply here.

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

Keeping Format Importing From Excel 8
Import Excel Spreadsheet and expand into multiple rows 1
import rows from excel into Access 1
Excel Save As Options 2
Importing date fields from Excel to Access 1
Access import not handling ALT+ENTER char from Excel 0
Custom Number Formats for Excel 2007 1
Exporting from Access to Excel keeping EXCEL formatting 2

Back
Top