Simple take away "us" in "usibm"

P

Phillip Vong

I have a simple Cell A1 that contains usibm and I want to put a formula in
B1 that will take away the "us" so it will only give me "ibm".

I know adding is something like ="us"&A1 but what is the command to take
away?

Thanks in advance.
 
N

Niek Otten

=right(A1,3)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message |I have a simple Cell A1 that contains usibm and I want to put a formula in
| B1 that will take away the "us" so it will only give me "ibm".
|
| I know adding is something like ="us"&A1 but what is the command to take
| away?
|
| Thanks in advance.
|
|
 
P

Phillip Vong

Thanks, but I guess I should have made it a little clearer. I have a whole
bunch of things starting with "us" like "usmsft" or "us123456789".

No matter how long the string is, I need EVERYTHING after the "us".
 
C

CLR

Just for grins.........another way

=MID(A1,FIND("us",A1,1)+2,99)

Vaya con Dios,
Chuck, CABGx3
 
Top