Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
=A1&", "&B1&" "&C1
HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Soth" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
=A1&", "&B1&" "&"0"&C1
Vaya con Dios, Chuck, CABGx3 "Soth" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
You are one super smart. Thank you.
"CLR" wrote: =A1&", "&B1&" "&"0"&C1 Vaya con Dios, Chuck, CABGx3 "Soth" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Just in case the Zip Code has less than 4 digits...
=A1&", "&B1&" "&TEXT(C1,"00000") CLR wrote: =A1&", "&B1&" "&"0"&C1 Vaya con Dios, Chuck, CABGx3 "Soth" wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
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 "Soth" wrote: You are one super smart. Thank you. "CLR" wrote: =A1&", "&B1&" "&"0"&C1 Vaya con Dios, Chuck, CABGx3 "Soth" wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Glenn wrote:
Just in case the Zip Code has less than 4 digits... OR exactly 5 digits: =A1&", "&B1&" "&TEXT(C1,"00000") CLR wrote: =A1&", "&B1&" "&"0"&C1 Vaya con Dios, Chuck, CABGx3 "Soth" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|