Trim with Country code leading
Try
=MID(A1,FIND(" ",A1)+1,LEN(A1))
If this post helps click Yes
---------------
Jacob Skaria
"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
|