+ Reply to Thread
Results 1 to 4 of 4

Multiply cell with text to other cells

  1. #1
    Registered User
    Join Date
    05-23-2020
    Location
    Denmark
    MS-Off Ver
    Newest
    Posts
    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. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    375

    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
    Attached Files Attached Files
    Never stop learning!
    <--- please consider *-ing !

  3. #3
    Registered User
    Join Date
    05-23-2020
    Location
    Guwahati, Assam, India
    MS-Off Ver
    2019
    Posts
    16

    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"
    Asha Kanta Sharma
    Guwahati, India

  4. #4
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    375

    Re: Multiply cell with text to other cells

    Quote Originally Posted by ashakantasharma View Post
    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: copy to clipboard
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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