Hey, i have to put some stuff into excel, and it was sent to me looking
like this (not in excel):

mike blue 23 42 53 132
25

mike red 66 4 43 632
67

jane likened 234 53 74 65
64

jane fly 243 33 365 3465
3456


The data is not accurate, and not really important, other than the
duplicate mike mike jane jane. Is there any way i can copy this whole
thing, and just paste it into a spreadsheet? other than going through
and putting it into each and every cell? thanks


--
Iamxerocool
------------------------------------------------------------------------
Iamxerocool's Profile: http://www.excelforum.com/member.php...o&userid=24977
View this thread: http://www.excelforum.com/showthread...hreadid=385072

have a go.

After the paste you may have to use <data<text to columns<

Greetings from New Zealand
Bill K
"Iamxerocool"
wrote in message
...

Hey, i have to put some stuff into excel, and it was sent to me looking
like this (not in excel):

mike blue 23 42 53 132
25

mike red 66 4 43 632
67

jane likened 234 53 74 65
64

jane fly 243 33 365 3465
3456


The data is not accurate, and not really important, other than the
duplicate mike mike jane jane. Is there any way i can copy this whole
thing, and just paste it into a spreadsheet? other than going through
and putting it into each and every cell? thanks


--
Iamxerocool
------------------------------------------------------------------------
Iamxerocool's Profile:
http://www.excelforum.com/member.php...o&userid=24977
View this thread: http://www.excelforum.com/showthread...hreadid=385072

Try this:

Data - Text to columns
delimited - space


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=385072