SamAshN
06-15-2007, 06:27 AM
New to the forum. Very nice collection of information!
My question is this...
When I highlight some info on the web and paste it into excel, it puts all of the info in one cell (I presume like a string):
A1 = 12 13 20 15 1 6 8 30
is there a way to have excel look at that one cell, and pull all of those numbers out and put them in their own cell?
A1 = 12 A2 = 13 A3 = 20 A4 = 15 A5 = 1 A6 = 6 A7 = 8 A8 = 30
Right now I'm doing it manually. Of course this sucks, and is prone to errors. Any help with this would be much appreciated.
Thanks.
My question is this...
When I highlight some info on the web and paste it into excel, it puts all of the info in one cell (I presume like a string):
A1 = 12 13 20 15 1 6 8 30
is there a way to have excel look at that one cell, and pull all of those numbers out and put them in their own cell?
A1 = 12 A2 = 13 A3 = 20 A4 = 15 A5 = 1 A6 = 6 A7 = 8 A8 = 30
Right now I'm doing it manually. Of course this sucks, and is prone to errors. Any help with this would be much appreciated.
Thanks.