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

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

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

Trim with Country code leading
 

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