+ Reply to Thread
Results 1 to 2 of 2

separating numeric values separated by comma in 1 cell to diff cells

  1. #1
    Registered User
    Join Date
    07-17-2008
    Location
    iceland
    Posts
    1

    separating numeric values separated by comma in 1 cell to diff cells

    if i have a number of numeric values display in a cell which are separated by a comma then how do i display each numeric value in a new cell?

    for eg.

    if cell A1 has data -- 1234, 78597, 84649357, 75952759,....
    how do i display each value in a new cell?
    like
    A1.... 1234
    A2.... 78597
    A3.... 84649357
    A3.... 75952759
    and so on.

    you can do it manually but is there any faster way of doing it?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcoome to the forum.

    Data > Text to columns, Delimited, Comma

+ 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