If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Leading zero's in text join
if it is formatted as text, it should not strip off the
leading 0. -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|