Combining formatted columns
 

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?

Combining formatted columns
 

What's you format? Use

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

replace the zeros with your custom format in the text formula


--
Regards,

Peo Sjoblom


"beerguy" wrote in message
...
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?

Combining formatted columns
 

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!

"Peo Sjoblom" wrote:

What's you format? Use

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

replace the zeros with your custom format in the text formula


--
Regards,

Peo Sjoblom


"beerguy" wrote in message
...
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?

Combining formatted columns
 

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?


--
Regards,

Peo Sjoblom



"beerguy" wrote in message
...
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!

"Peo Sjoblom" wrote:

What's you format? Use

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

replace the zeros with your custom format in the text formula


--
Regards,

Peo Sjoblom


"beerguy" wrote in message
...
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?