formula to delete all but the last 3 characters

Does anyone know the formula to delete all but the last 3 characters?

Thanks in advance

Originally Posted by duugg

Does anyone know the formula to delete all but the last 3 characters?

Thanks in advance

Assuming you're referring to one cell (A1 in this example):

=RIGHT(A1,3)

You may also wish to consider the following formula, which will remove any accidentally inserted spaces at the end of the string (it also removes double spaces from the middle -- you will have to determine if this is appropriate for what you are doing).

=RIGHT(TRIM(A1),3)

Scott

Maistrye,

Thanks! it worked!

Do you happen to know if there's a way to delete all rows above the bottom most one that have the same data in it.

For example...

B2
C2
D2

All have the same 3 characters in it, let's say CNW.

There is also irrelevant data in B1, C1 & D1

I would like to automatically delete rows B & C and leave row D in there. Do you know if this can be done?