Formatting Truncate

[dragonmouse]

I have a cell with 5581004490451CS: 200. I don't want the whole text displayed (it was imported from a database). I would rather it display only "0451CS: 200" Any easy ideas?

 

[Scott Huish]

If you just want to get rid of the rest:
=RIGHT(A1,11)

 

[dragonmouse]

Thank you. NOW I remember ... You are right on the money!