Looking for the logic to concatenate cells, however I need one of those cells 
to duplicate X number of times:

Such as CONCATENATE(d1, b1, b3)  B3 being the value I want to return 
multiple times:

d1=1
b1=2
b3=4

I would like my results to come out: 1244444444

Any help?

Use the following UDF:

Function Mergit(a, b, c)
Mergit = a & b & c & c & c & c & c & c & c & c
End Function
-- 
Gary's Student


"SCHNYDES" wrote:

> Looking for the logic to concatenate cells, however I need one of those cells 
> to duplicate X number of times:
> 
> Such as CONCATENATE(d1, b1, b3)  B3 being the value I want to return 
> multiple times:
> 
> d1=1
> b1=2
> b3=4
> 
> I would like my results to come out: 1244444444
> 
> Any help?

=D1&B1&B3&B3&B3&B3&B3&B3&B3&B3
There may be a more elegant solution.
************
Anne Troy
www.OfficeArticles.com

"SCHNYDES" <SCHNYDES@discussions.microsoft.com> wrote in message 
news:185F9029-B267-4045-9E8D-BF1BDB039D78@microsoft.com...
> Looking for the logic to concatenate cells, however I need one of those 
> cells
> to duplicate X number of times:
>
> Such as CONCATENATE(d1, b1, b3)  B3 being the value I want to return
> multiple times:
>
> d1=1
> b1=2
> b3=4
>
> I would like my results to come out: 1244444444
>
> Any help? 

Try this:

=D1&B1&REPT(B3,8)

-- 
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"SCHNYDES" <SCHNYDES@discussions.microsoft.com> wrote in message
news:185F9029-B267-4045-9E8D-BF1BDB039D78@microsoft.com...
> Looking for the logic to concatenate cells, however I need one of those
cells
> to duplicate X number of times:
>
> Such as CONCATENATE(d1, b1, b3)  B3 being the value I want to return
> multiple times:
>
> d1=1
> b1=2
> b3=4
>
> I would like my results to come out: 1244444444
>
> Any help?

Just in case you might need a *true* number returned:

=--(D1&B1&REPT(B3,8))
-- 
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:ur4J9Np1FHA.164@TK2MSFTNGP10.phx.gbl...
> Try this:
>
> =D1&B1&REPT(B3,8)
>
> -- 
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
>
> "SCHNYDES" <SCHNYDES@discussions.microsoft.com> wrote in message
> news:185F9029-B267-4045-9E8D-BF1BDB039D78@microsoft.com...
> > Looking for the logic to concatenate cells, however I need one of those
> cells
> > to duplicate X number of times:
> >
> > Such as CONCATENATE(d1, b1, b3)  B3 being the value I want to return
> > multiple times:
> >
> > d1=1
> > b1=2
> > b3=4
> >
> > I would like my results to come out: 1244444444
> >
> > Any help?
>