PDA

View Full Version : Basic Question?



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.

mikerickson
06-15-2007, 06:30 AM
Through paste options you can use the import Wizard.
Or if its too late for that you can use Data-Text to Columns.

SamAshN
06-15-2007, 06:43 AM
Paste Special did it. I figured it was something simple. Thank You.

Charlize
06-15-2007, 07:01 AM
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