+ Reply to Thread
Results 1 to 3 of 3

Repeating a Text String a Fixed Number of Times

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    810

    Repeating a Text String a Fixed Number of Times

    Hi,

    I have a list of text names in A2:A30 and would like to create a formula in column C that will put into cells in that column 13 instances of each item in A2:A30. For example, if A2 contains the word “Hello” and A3 has “Goodbye”, C1: C13 will contain “Hello” and C14 to C26 will contain “Goodbye”.

    Can someone please suggest a formula that will accomplish this.

    Thanks!
    Last edited by andrewc; 10-21-2013 at 10:06 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Repeating a Text String a Fixed Number of Times

    Here, try this:

    change number 13 to whatever you like:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    810

    Re: Repeating a Text String a Fixed Number of Times

    That's great, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting the number of times a text string occurs in a cell
    By Geoff1184 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-12-2012, 04:07 PM
  2. [SOLVED] Average number of times a text string occurs
    By anguschap in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2012, 08:22 PM
  3. Repeating a number 3 times
    By bikersnm in forum Excel General
    Replies: 7
    Last Post: 05-12-2009, 04:02 AM
  4. Repeating items a specific number of times
    By ninja0059 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2008, 01:19 PM
  5. Replies: 6
    Last Post: 01-30-2008, 01:30 PM

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