formula help

S

Soth

Hi-

Sample:

A B C
City State Zipcode

Boston MA 2202

I have two following questions:

1. I have address in a spreadsheet in separate column A, B, C and I like to
have this fomat as Boston, MA 2202. What is this correct formula? I try to
'&' but I has no 'comma' and 'space'.

2. The zipcodes have no zero infront and how do I add zero ? I do not want
to do individual because I have thousands of zipcodes.

Thank you for your help.
 
C

CLR

Thank you for the kind words, but it's more a matter of just having been
there before.

I'm happy to have been of some help.

Vaya con Dios,
Chuck, CABGx3
 

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

Top