View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cassius Cassius is offline
external usenet poster
 
Posts: 4
Default Trim with Country code leading

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