-
Basic Question?
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.
-
Through paste options you can use the import Wizard.
Or if its too late for that you can use Data-Text to Columns.
-
Paste Special did it. I figured it was something simple. Thank You.
-
[VBA]Sub redo_paste()
Dim varray
Dim vloop As Long
varray = Split(Cells(1, 1), " ")
For vloop = LBound(varray) To UBound(varray)
Cells(vloop + 1, 1).Value = varray(vloop)
Next vloop
End Sub[/VBA]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules