CONCATENATE

  • Thread starter Thread starter lehigh
  • Start date Start date
L

lehigh

Hi All:

In columns Q, R & S I have.............. City, State & Zip

In column T, I concatenate the three, as follows:

=Q5&", "&R5&" "&S5

The question is......How can I create a formula to show the zip with 5
characters with leading zeros ?

Thanks for your help

Tom Snyder
 
Tom,

Use the TEXT function to expand the zip code to 5 zeros. E.g.,

=Q5&", "&R5&" "&TEXT(S5,"00000")
 
Back
Top