+ Reply to Thread
Results 1 to 7 of 7

Series numeric number spliting problem.

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Series numeric number spliting problem.

    hi ppl,

    please help me to solve the splitting problem.

    how to split 1 ~ 3, 4, 5 in to rows with each cell each number.

    example :


    From: A 1~3, 4, 5

    To : A 1
    A 2
    A 3
    A 4
    A 5


    thanks

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Series numeric number spliting problem.

    hi - a few questions
    • is the string to split contained in a single cell or successive ones?
    • are the characters to split separated by commas, spaces or other characters?
    • what does this symbol represent - " ~ "

  3. #3
    Registered User
    Join Date
    01-04-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Series numeric number spliting problem.

    hi,

    thanks to your response,

    1. all the data original in one cell, which mean 1~3, 4, 5 in one cell. i wan to separate these numeric data into multiple cell such like 1~3, 4, 5 to 1 2 3 4 5 for each cell

    2. each number is separate by commas

    3. ~ mean continuous number. which mean 1 ~ 3 = 1 till 3 = 1 2 3


    thanks

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Series numeric number spliting problem.

    hi
    try this macro

    Please Login or Register  to view this content.

  5. #5
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Series numeric number spliting problem.

    Hi jmloo80

    I am assuming you mean that you have a cell that has: 1,2,3,4,5 !
    If so, assuming the cell in question is A1, then try this formula, say in cell B1 and copy down..
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  6. #6
    Registered User
    Join Date
    01-04-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Series numeric number spliting problem.

    hi NickyC,

    the macros works..... thanks a lot.

  7. #7
    Registered User
    Join Date
    01-04-2013
    Location
    penang, malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Series numeric number spliting problem.

    hi kelvin,

    thanks to your help too

+ 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