Combining formatted columns

B

beerguy

I have added leading zeros to cell contents in 2 columns. To link data in
this spreadsheet to another one, I need to concatenate the columns. When I
do this, I lose the leading zeroes from each column, which need to remain if
I expect to link the spreadsheets. What's the solution?
 
P

Peo Sjoblom

What's you format? Use

=TEXT(A1,"0000")&" "&TEXT(B1,"0000")

replace the zeros with your custom format in the text formula
 
B

beerguy

Awesome! Will the format of the cell (text) be an issue if the cell in the
other spreadsheet is not text? That is, is format and content important when
doing the LOOKUP? Thanks again for the great tip!
 
P

Peo Sjoblom

Yes but you can fix that by making the lookup value either text or number
depending on what the lookup table values are
What's you lookup formula?
 
Top