Excel 2002 column info question

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

Hello, thanks for any advice. I have a 8034 record excel
spreadsheet that someone else created that a friend wants
me to create mailing labels from. Unfortunatly, the
creator put the city, state and zip into ONE column, the
last column!!!! is there an easy way to fix this so I can
import into an Access database to create mailing labels
and sort by city?

thanks!!!! any help is appreciated!
please e-mail me if you prefer: wonderinginnh(nospam)
@yahoo.com
 
You could try copying that last column to a new spreadsheet and then using 'text to columns' from the data menu to separate. Your Access query will then be able to link the data to perform your search.
 
You are the best!!!! IT WORKED!!!! thanks so much!!!

-----Original Message-----
You could try copying that last column to a new
Click to expand...
spreadsheet and then using 'text to columns' from the data
menu to separate. Your Access query will then be able to
link the data to perform your search.
 
Back
Top