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.
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.