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.
 

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

Moving info from rows to columns 2
Mailing address block: sorting 1 row to columns 1
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS 7
Problem with mail merge in Word/Excel 2002 1
Critical - Converting Single Column Address Data into Multiple Col 2
Use look-up table in Excel and enter into a "county" column, same 3
Sorting problem 2
Filtering an Excel Report 1

Back
Top