Trim with Country code leading

[Cassius]

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

 

[T. Valko]

If you want to completely remove them...

Select the cells in question
Goto the menu Data>Text to Columns
Select Fixed width>Next

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

 

[Jacob Skaria]

Try

=MID(A1,FIND(" ",A1)+1,LEN(A1))

If this post helps click Yes

 

[Shane Devenshire]

Hi,

Since the country code is 2 characters and a space is one than

=MID(A1,4,9^3)