+ Reply to Thread
Results 1 to 5 of 5

trying to add cells between each name

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    chesterfield
    MS-Off Ver
    2016
    Posts
    10

    Question trying to add cells between each name

    Capture.PNG
    Captured.PNG

    Ok her is my problem I managed this in 2016 but can not remember how the hell I did it.....

    I have a list of names s in pic 1 and I would like to put 14 spaces in between each name as in pic 2, I have just spent 9 hours on this and failed so I thought I would ask here


    now before anybody says just add rows there are 2500 names,,,,
    Last edited by iwannawinit; 06-18-2019 at 05:42 PM.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: trying to add cells between each name

    Hi

    Try this in a new column
    If your data is in A2:A2500 Try in B2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-18-2019
    Location
    chesterfield
    MS-Off Ver
    2016
    Posts
    10

    Re: trying to add cells between each name

    absoloute genius,,, 9 hours of kicking the computer, and you do it in 2 mins lol,,,thank you very much

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: trying to add cells between each name

    You are welcome. I'm happy to have helped

    Please select Thread Tools from the menu link above and mark this thread as SOLVED.
    You do not need 9 hours to do that.
    Thanks.

  5. #5
    Registered User
    Join Date
    06-18-2019
    Location
    chesterfield
    MS-Off Ver
    2016
    Posts
    10

    Question Re: trying to add cells between each name

    Ok so here is another question... I have sheet 1 which is a list of names in the above format so I have 15 off name 1,, 15 name 2, 15 name 3 etc....
    and sheet two is sheet 1 reduced back to single names...

    for instance sheet 2 name AABIR comes from the A1 cell on sheet 1... and the second name AACHEN comes from cell A16 on sheet 1

    So I have a sort of reverse to your great post,,, where i am trying to get every 15th name on sheet 2, from sheet 1
    Capture.PNG
    Captured.PNG
    Last edited by iwannawinit; 06-18-2019 at 07:16 PM.

+ 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. [SOLVED] Count the cells in a string of cells omitting zeros and specific cells
    By Hawkmoth1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2017, 08:39 AM
  2. Replies: 4
    Last Post: 02-11-2015, 09:02 AM
  3. Replies: 0
    Last Post: 01-21-2015, 12:05 PM
  4. [SOLVED] Linking cells globally to allow users the ability to change cells on separate sheet/cells.
    By V1gilante in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 10:47 PM
  5. Replies: 4
    Last Post: 06-17-2011, 08:53 AM
  6. Formula: Drop Down List -> Choose Option Finds Cells & Replace Cells with Cells
    By g00glethis1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2010, 01:10 PM
  7. Replies: 2
    Last Post: 06-24-2010, 04:53 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