Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel help needed

Status
Not open for further replies.

mlmrob

Technical User
Jan 5, 2005
14
GB
When I copy and paste horseratings from adrianmassey.com into a spreadsheet i get the following

Horsename121238783
rather than each being in a sepaerate column reading

Horsename 12 12 38 783

As I have just got a new computer , running XP and Home works I am a bit baffled as it worked okay on my old machine that had 98 on.

On there it was just a case of copying & pasting but now I just get the horses name followed by a load of numbers.
The paste special isn't highlighted either so I am bit confused.

if any of you guys have any ides it would be much appreciated.

many thanks

Rob
 

Hi,

Use Data/text to Columns -- FiXed Width Option Button -- to Parse your string.

Skip,
[sub]
[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue][/sub]
 
Thanks, I haven't got a clue about what you are saying but I'll give it a go.
Your help is much appreciated

Rob
 


Menu item -- Data/Text to Columns...

Skip,
[sub]
[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top