Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging 3 rows of numbers together
I have 3 columns of numbers and in each row I need to merge the those 3
columns together to become one number. example: 50 00008895 2007. I can get them to merge but the formula keeps dropping the 0's -- Mary C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging 3 rows of numbers together
If you concatenate the three cells like this
=A1&B1&C1 and the zeros before 8895 get dropped, it may be that 8895 is stored as a number with a custom format (like "00000000") to display the leading zeros. If it was stored as text, it should keep the zeros when you concatenate it. If the entries in the 00008895 column are always 8 characters, then a formula like the following may work for you: =A1&TEXT(B1,"00000000")&C1 Hope this helps, Hutch "Mary C" wrote: I have 3 columns of numbers and in each row I need to merge the those 3 columns together to become one number. example: 50 00008895 2007. I can get them to merge but the formula keeps dropping the 0's -- Mary C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging 2 excel sheets with numbers and words | New Users to Excel | |||
Is merging rows possible? | Excel Worksheet Functions | |||
When merging phone numbers do not keep formatting why? | Excel Worksheet Functions | |||
Merging data looking up (Account) numbers in a coloumn | Excel Worksheet Functions | |||
Merging rows | New Users to Excel |