Results 1 to 4 of 4

Separate input numbers into separate columns.

Threaded View

  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.

    Sub SeparateLines()
    '
    '
        Range("H2:H10001").Select
        Selection.Copy
        ActiveWindow.SmallScroll Down:=-99
        Range("I2").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        ActiveWindow.SmallScroll Down:=-21
        Application.CutCopyMode = False
        Selection.TextToColumns Destination:=Range("I2"), DataType:=xlDelimited, _
            TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
            Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
            :=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
    End Sub
    Thank you for help!
    Attached Files Attached Files
    Last edited by Tona; 12-16-2015 at 03:26 AM.

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. [SOLVED] 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