| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| Can a Text Box be Formatted in Columns? | Excel Discussion (Misc queries) | |||
| Deleted Columns replaced with formatted columns | Excel Discussion (Misc queries) | |||
| Getting information from 2 difference formatted columns | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Hybrid Mode
