selecting numbers from strings and combining them

[luka]

Hello all, I have a spreadsheet in which I have 2 strings of numbers that I need to combine:
example:
1st cell- 12,14,16,18
2nd cell- 3,6,7,8
Now what i need to create is:
12*3|14*6|16*7|18*8
This has to be flexible because there might be more or less numbers in each string

Thank you for your time in advance!

Luka

[rvasquez]

Hello there,

If the first number is in cell A1 and the second number is in cell B1 then in C1 place

Please Login or Register  to view this content.

Copy this code down column C to the end of your data.

[BenMiller]

Do you want them all to end up in the same cell?

[luka]

Maybe I didn't structure my question correctly. Let me explain this again
A1- 12,14,16,18 but might also have more numbers
B1- 3,6,7,8 might also have more numbers
However the quantity of numbers in a1 and b1 will always be equal
Now in C1 i need a formula to create this
12*3|14*6|16*7|18*8

[rvasquez]

Sorry about that, personally I would use the Text To Columns Option under the Data tab to seperate the numbers. To do this Go to the Data tab and then select Text To Columns. In the Convert Text Wizard Windown select Delimited as your first option then select Next. On the next option Select Comma and deselect all other options. Then select Next. On the next Step select Finish.

This will seperate the numbers. Then you can use the formula provided below to concatenate them.

Does this sound like it would work?

[luka]

Not really because as I said the formula has to be flexible...both a1 and b1 are numbers typed in by the user and there might be hundreds of strings like that with different lengths...

[rvasquez]

Could you please provided an example worksheet. Are the users entering data into only a certain cell or are they constantly entering new information in?

Thanks!