Combining formatted columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
What's you format? Use

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

replace the zeros with your custom format in the text formula
 
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!
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formatting 1
Array formula to Identify Leading Zeros. 2
Join three columns containing phone number and format as (000) 000 5
Find/Replace changes cell format ?????? 2
How do I stop Excel from dropping leading zeros? 9
losing the leading zero when merging zip+4 postal code 1
time format 1
Need 7 digit number with differnt number of leading zeros 10

Back
Top