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.

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.

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(LEN(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" <(E-Mail Removed)> wrote in message
news:004F11A2-74B0-4896-A922-(E-Mail Removed)...
> 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.

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 <Muthal...@discussions.microsoft.com>
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.

Derrr!! <bg>

No excuses
Martin

"Pete_UK" <(E-Mail Removed)> wrote in message
news:57b94ffb-7999-4f28-92ad-(E-Mail Removed)...
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 <Muthal...@discussions.microsoft.com>
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.

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 <Muthal...@discussions.microsoft.com>
> 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.
>
>

You're welcome - thanks for feeding back.

Pete

On Jun 24, 2:35*pm, Muthalaly <Muthal...@discussions.microsoft.com>
wrote:
> Thank you so much for the help!!!
>