Results 1 to 3 of 3

How can I seperate numbers followed by a comma from a string

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2011
    Location
    Guam
    MS-Off Ver
    Excel 200
    Posts
    2

    How can I seperate numbers followed by a comma from a string

    Can someone please help me how to extract numbers from a string to seperate colums that is seperated by a comma
    103,19810321,20,12,1,1,19,394,2,-
    119,198,38,4,62,37,9,36,1274589,-
    125,1,10,31,18458,8,35,394,32,-
    etc the problem I can't use mid-function because the numbers could be 1 digit or even upto 8 or 9 digits. Please help!!!
    Last edited by jaymullasseril; 07-30-2011 at 01:42 AM.

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