Excel help pls

google =countif

will do ta

sorted, cheers

not a problem

Raceform data downloaded into excel and all data in one cell.
Used to do it with wizard and use ' delimiter but that doesn't seem to work
Tried splitting the cells with "Text to Columns" but cells still overlap with various data.
Any suggestions

I managed to sort some stuff recently using FIND,LEN and LEFT. It was messy and I'm not sure I could even do it again without a lot of thought, but googling those three might help.

Google show all text to the left of a symbol in excel and things along those lines might help

Pinza, not sure if it applies in your case if you're using Interactive, but i know RP data downloads into one cell when using Internet Explorer, and into separate cells with Firefox.

+ maybe just give them a call? the tech guy on interactive seems reasonably helpful

Thanks guys.

Get the wizard up
click on "other" and use key on the left next to shift
which will give you |
That has sorted out the data in all the cells

good stuff Pinza! no doubt will need that in the future