Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Logic for Placing Multiple field Returns in a Cell
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? |
#2
|
|||
|
|||
Logic for Placing Multiple field Returns in a Cell
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? |
#3
|
|||
|
|||
Logic for Placing Multiple field Returns in a Cell
=D1&B1&B3&B3&B3&B3&B3&B3&B3&B3
There may be a more elegant solution. ************ Anne Troy www.OfficeArticles.com "SCHNYDES" wrote in message ... 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? |
#4
|
|||
|
|||
Logic for Placing Multiple field Returns in a Cell
Try this:
=D1&B1&REPT(B3,8) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "SCHNYDES" wrote in message ... 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? |
#5
|
|||
|
|||
Logic for Placing Multiple field Returns in a Cell
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" wrote in message ... Try this: =D1&B1&REPT(B3,8) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "SCHNYDES" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
If function that returns value in a cell. | Excel Worksheet Functions | |||
Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
Multiple lines in 1 cell | Excel Discussion (Misc queries) |