Trim with Country code leading
If you want to completely remove them...
Select the cells in question
Goto the menu DataText to Columns
Select Fixed widthNext
In the Data preview area use your mouse and double click where you want the
data separated. If Excel has already guessed and inserted separators just
double click on them to remove them. Based on your description you want to
insert a separator after the 3rd character.
After you have inserted the separator click Next
In the next step of the wizard the data you want to strip out should be
highlighted. Select Do not import column (skip).
Click Finish
--
Biff
Microsoft Excel MVP
"Cassius" wrote in message
...
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
|