# Multiply cell with text to other cells

1. ## Multiply cell with text to other cells

Dear experts

(sorry for my bad english spelling upfront).

I have an excel-sheet where I would like to dublicate cells by multiplying them to others cells with numbers in them.

Fx:

(cell A1)
example(at)example.com

(cell B1)
5

Now I would like to multiply example(at)example.com to the number in cell B1 so that I get 5 cells with the email in it.

Does it make sense - and is it possible?

//Kugelblitz

2. ## Re: Multiply cell with text to other cells

If you insert this into the worksheet's VBA module, it'll do this in its most basic form and duplicate the A1 value in column C.
``Please Login or Register  to view this content.``
You will have to consider what to do if a new B1 value is less than the former value as there will be redundant data left in column C (in this example), but this should get you started.

Try putting your data in A1 and B1 of the attached to see...

Tim

3. ## Re: Multiply cell with text to other cells

I have tried it but have not found out simple process. It is a bit lengthy process.

First, You put a unique sign at the end of each and every email address like "-, /, &"etc
Secondly, use =REPT formula to repeat the email address with the number of times as required (Link the same to the number of times required)
Thirdly, You will get all the data as repeated in a single cell. Now use Text to Column option and use the unique sign used previously to differentiate each cells to each respective cells "-, /, &"etc
Fourthly, Now copy data of the single cell and paste it as "TRANSPOSE"

4. ## Re: Multiply cell with text to other cells

Originally Posted by ashakantasharma
First, you put a unique sign at the end of each and every email address like "-, /, &"etc
secondly, use =rept formula to repeat the email address
This will give you the repetitions without having to mangle the email addresses:
Formula:
`Please Login or Register  to view this content.`

Otherwise your approach would work, but would still have to use VBA to do the transposing automatically. If you're going to have to use VBA, you might as well just do the whole lot with a macro.

Tim

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1