How do I count from the left upto the comma

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

Here, try this:

Formula:

Please Login or Register  to view this content.

sure.
It's better to put same value for both:

Please Login or Register  to view this content.

Since you can not "cut" less than 300 (as you add 300 spaces), a no need to cut word longer than 50

This is not same as you looking for "first space" because it's more likely that first space will appear in less than 50 characters, but looking for first comma will cut your sentence since it might never appear.

This might never happend but it's worth to consider it.

No problem.
It will also work just ajbaldwin can be aware of potential output.

Works a treat, thanks all