View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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