Leading zero's in text join

  • Thread starter Thread starter Trevor Shuttleworth
  • Start date Start date
T

Trevor Shuttleworth

Raymond

something like:

=A1&" "&B1&", "&TEXT(C1,"0000000")

Not sure how many zeroes you need; adjust to taste.

Regards

Trevor
 
Hi Ray

Crossposting from a pre-dated computer is not nice. Simple stuff like this
is easily solved in a single newsgroup. Now we have to watch this thread on
top of our newsreaders in all groups the next two days, or spend lots of
time removing it, each one of us. Don't do it again please.

Best wishes Harald
 
Ray, how did you get Time Travel?


Raymond Pistey Jr said:
I have 4 colums a,b,c,d

I use A1&" "&B1&", "&C1 in colum d to combine the text into one cell. (city,
state and zip) My problem is that colum c is the zip code cell and it's
formatted that way, when it combines to colum d it strips the leading zero
off the zips. is there a way to format the ' apostrophe in and where?

thanks

ray pistey
Click to expand...
 
I have 4 colums a,b,c,d

I use A1&" "&B1&", "&C1 in colum d to combine the text into one cell. (city,
state and zip) My problem is that colum c is the zip code cell and it's
formatted that way, when it combines to colum d it strips the leading zero
off the zips. is there a way to format the ' apostrophe in and where?

thanks

ray pistey
 
Back
Top