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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!