Delete specific characters from a string in a cell

[mcgew]

Does anyone know how to remove certain characters from a string in a cell?
I have a list like this:
N108KC/575
N108KC/59838/1
N108KC/59838/2
N108KCA/8063/170
N108KCM/950


And I want to remove the first 5 characters from those to look like this:
C/575
C/59838/1
C/59838/2
CA/8063/170
CM/950

I can't use Right() formula as all the strings are different lengths - are there any other formulas or a macro I could use?
Thanks

 

[btadams]

try:

=RIGHT(A1,LEN(A1)-5)

 

[RichardS]

You could use right(A1,len(A1)-5)

Or if the stuff to remove is constant, use find and replace N108K with nothing.

Richard

 

[Cloverken]

assuming N108KC/575 is in cell A1 this would work


=RIGHT(A1,LEN(A1)-5)

I knew I wouldn't be fast enough. Oh now that is funny

 

[mcgew]

Thank you all - that's going to save me SO much time!!