Text Functions...... SOLVED

Morning all,

A quick one for you all. I have a column of data which lists countries and currency codes, a section of which is below.

Argentina, Pesos
Australia, Dollars
Barbados, Dollars

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 !!
:tongue:

Sussed it, maybe I'm not as much of a drongo as I thought !! :bouncing:

=MID(AB6,1,FIND(", ",AB6,1)-1)