Greetings All

Can someone please point me in the right direction with this

I am trying to capture the first location upto but not including the comma in a large range of information I have tried various Right from etc but I need something a bit more sophisticated like a find upto

My data is:

Lancashire, Todmorden
Halifax, Elland
West Yorkshire, Brighouse
Huddersfield, Cloth Hall Street
Newcastle Upon Tyne, Haymarket

So need to return in the next cell, Lancashire, then Halifax in the next etc

Can anyone point me in the right direction?

Thanks
Adam