A quick one for you all. I have a column of data which lists countries and currency codes, a section of which is below.
In the next column I would like to place a function ( LEFT maybe ??) that returns only the country name, or anything that appears before the comma.
I'm sure it's dead simple, but unfortunately so am I !!