Hi,

Since the country code is 2 characters and a space is one than

=MID(A1,4,9^3)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Cassius" wrote:

I have some cells with two charcters leading and those are generally the
country code. How can I parse those out the country code and space to just
see the supplier name?

For example:
AU BBL DOWNHOLE TOOLS LTD
MX PATRULLAS DE ALARMA DE TABASCO
SG CANTEEN 11