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.
Hi,
Use "Text To Columns" to separate the text string delimited by commas.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Re: How can I seperate numbers followed by a comma from a string
thanks!!! it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks