Simple take away "us" in "usibm"

[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.

 

[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.
|
|

 

[Ken Puls]

Or, if you always want to remove the left two characters:
=right(A1,len(A1)-2)

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[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".

 

[Phillip Vong]

Ken, that's perfect. That's exactly what I was looking for.

 

[Guest]

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

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

Vaya con Dios,
Chuck, CABGx3