need to make 3 fields into 1 field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an mail list that has been created with 3 address fields. These
fields need to be consolidated into 1 field. Can this be done.

Thanks
 
Georgia

Most programs that use Adresses like them in separate fields but if you need
in one field......

=A1 & " " & B1 & " " & C1

The " " are to insert spaces.

Gord Dibben Excel MVP
 
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

Access Skip address field if previous field is blank 2
Split data in field on character return 0
Access Access - Is it possible to repeat fields in a form? 1
How do I consolidate data from several spreadsheets into one. 4
How to finding student Rank and How to upload bulk marks of each student at a time. 1
dynamic calculated field in query 3
Access Daily Entry with multiple entries per field 0
Importing Text Files Into Access 1

Back
Top