+ Reply to Thread
Results 1 to 4 of 4

Separate input numbers into separate columns.

  1. #1
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Separate input numbers into separate columns.

    I'm using macro that separates input in cell eg. "1,2,3,4" into separate columns as shown in attached workbook on sheet "Current".

    How could I amend macro that it would separate inputs as shown in attached workbook on the sheet "How it should be".

    The input numbers will be always in range from number 1 to maximum number 20.

    Please Login or Register  to view this content.
    Thank you for help!
    Attached Files Attached Files
    Last edited by Tona; 12-16-2015 at 03:26 AM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Separate input numbers into separate columns.

    Hi Tona,
    try this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Separate input numbers into separate columns.

    You are The man!

    Small explanation please: How should I change macro if my "I" column is "AF" and else follows accordingly?
    Last edited by Tona; 12-16-2015 at 03:35 AM.

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Separate input numbers into separate columns.

    change this line
    Please Login or Register  to view this content.

+ 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. Replies: 2
    Last Post: 11-10-2015, 12:23 PM
  2. [SOLVED] Match Multiple Columns from Separate Sheet to get separate column.
    By gvitoro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2014, 03:38 PM
  3. [SOLVED] Separate numeric/text combination into two separate columns.
    By Jim15 in forum Excel General
    Replies: 6
    Last Post: 10-09-2013, 05:49 PM
  4. [SOLVED] Extract and separate the letters into their own separate columns
    By siroos12 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-22-2013, 10:18 AM
  5. Replies: 10
    Last Post: 03-08-2012, 12:31 PM
  6. How to Separate Chunks of Characters and put them in separate Columns
    By crisshinn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-08-2011, 10:16 AM
  7. I wish to separate city, state, and zip into 3 separate columns
    By Bob Woolbert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2006, 01:45 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