Hi

I use MS Excel to analyse form data which I currently manually type into my spreadhseet using Racing and Sports form guide. To try and save on the manual labour I have been trying to "copy and paste" data from various websites to save manual data entry. One of the problems I am coming up against is that certain data (eg: last four starts) gets pasted into a single cell in Excel "3x45" or "1121" etc. Same problem arises with a horses distance record eg: 21 starts for 1 1st and 3 nds and 0 thirds means that 21-1-3-0 appears as a (text string?) in a single cell in Excel.

I need to break this data up into separate cells to run my calculations eg: last four starts would have 1 1 2 1 in four separate cells - but am unclear whether Excel has the funtionality to allow me achieve this?

Has anyone any experience or advice they can provide?

I'd also greatly appreciate any advice from the forum on god sources of electronic form data (Southcoast?) - manual labour is not for me!

Thanks everyone