Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
Hi,
I am trying to concatenate two fields in excel.In this one field is a cutom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
hi
i suspect that the 00123 is formated with leading zeros meaning that the zeros are not there to concatinate. i think you may have to reform as text and add the leading zeros. regards FSt1 "Muthalaly" wrote: Hi, I am trying to concatenate two fields in excel.In this one field is a cutom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
Hi Muthalaly,
This is a bit long winded but you may be able to work it in to your formula. =IF(LEN(A1)=1,"0000"&A1,IF(LEN(A1)=2,"000"&A1,IF(L EN(A1)=3,"00"&A1,IF(LEN(A1)=4,"0"&A1,A1)))) With A1 formatted as custom 00000, this will add the formatted zeroes to your concatenation. Just add the abc where appropriate. HTH Martin "Muthalaly" wrote in message ... Hi, I am trying to concatenate two fields in excel.In this one field is a cutom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
Try this:
=TEXT(A1,"00000") & B1 with your number in A1 and the text in B1. Hope this helps. Pete On Jun 24, 12:12*pm, Muthalaly wrote: Hi, I am trying to concatenate two fields in excel.In this one field is a cutom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
Derrr!! <bg
No excuses Martin "Pete_UK" wrote in message ... Try this: =TEXT(A1,"00000") & B1 with your number in A1 and the text in B1. Hope this helps. Pete On Jun 24, 12:12 pm, Muthalaly wrote: Hi, I am trying to concatenate two fields in excel.In this one field is a cutom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
Thank you so much for the help!!!
"Pete_UK" wrote: Try this: =TEXT(A1,"00000") & B1 with your number in A1 and the text in B1. Hope this helps. Pete On Jun 24, 12:12 pm, Muthalaly wrote: Hi, I am trying to concatenate two fields in excel.In this one field is a cutom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenation in Excel
You're welcome - thanks for feeding back.
Pete On Jun 24, 2:35*pm, Muthalaly wrote: Thank you so much for the help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation in Excel 2003 | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation using IF AND - Possible? | Excel Worksheet Functions | |||
Excel needs to expand text concatenation capability | Excel Worksheet Functions |