CONCATENATE

[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

 

[Chip Pearson]

Tom,

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

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