Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
starfish and coffee
11 Nov 09 09:50
Joined:
Date Joined: 03 Sep 08
| Topic/replies: 8,055 | Blogger: starfish and coffee's blog
I regularly copy and paste cards from racing websites, however in the last 24 hours Excel has started pasting everything into separate cells e.g. horse name Do The Deal appears in 3 columns

This coincides with me starting to use the Delimited Text to Columns function but that was in a totally different spreadsheet

Most of the troubleshooting I can find on the net refers to separating text into columns, and not how to stop it so I would be very grateful for help
Pause Switch to Standard View Excel help please
Show More
Loading...
Report SHAPESHIFTER November 11, 2009 10:03 AM GMT
Might have mis understood but

COPY
then
SELECT CELL
then
PASTE SPECIAL
select
TEXT
Report starfish and coffee November 11, 2009 10:04 AM GMT
yup, thats what I always do and now it starts delivering in what for me is an unmanageable format by separating everything into separate cells
Report Ernesto November 11, 2009 10:54 AM GMT
when you paste is"space" ticked as a separator?
Report starfish and coffee November 11, 2009 1:04 PM GMT
Thanks the response, i cant see that option in 'copy and paste', only in 'text to columns' ?

I took the opportunity to upgrade my MS package in the meantime anyway and thats removed the problem
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com