+ Reply to Thread
Results 1 to 4 of 4

Multi-insert new columns in between

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Multi-insert new columns in between

    Hi!

    Anyone knows an easy solution to how I can insert a new column in between every column that I've already got? I've got a line of hundreds of columns where I need to insert a new cell in between every single one that I've already got. For examble ABCDEFG needs to become A B C D E F G... and so on. Do I really need to do that by hand for every single column I want to add?

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Multi-insert new columns in between

    Tinwelende, welcome to the forum.

    You may find the following post helpful: http://www.excelforum.com/excel-gene...g-columns.html
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    153

    Re: Multi-insert new columns in between

    Thank you! I didn't even know what key words to search for, looking for an already existing thread about the subject. :P Thanks for your help!

  4. #4
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Multi-insert new columns in between

    :-) I googled your thread title, and the result was on the first page.

    If your query has been answered to your satisfaction, woulc you please use the thread tools to mark it "Solved", thanks.

+ 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