LinkBack URL
About LinkBacks
A1 cell has: 2 345 4 567 5 678 6 789 (space delimited numbers, any number could be of any digit)
I want 8 new colums
b1=2, c1=345,d1=4,e1=567,f1=5, g1=678,h1=6,i1=789
Extract all numbers from a cell to different cols for each number
A1 cell has: 2 345 4 567 5 678 6 789 (space delimited numbers, any number could be of any digit)
I want 8 new colums
b1=2, c1=345,d1=4,e1=567,f1=5, g1=678,h1=6,i1=789
Did you try using the Text to columns feature under Data? You can select "Space" as the delimiter.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Re: Extract all numbers from a cell to different cols for each number
Thank you so much, it worked
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I will do it for you this time.
Last edited by arlu1201; 09-25-2012 at 07:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks