How do I trim the first x characters from a string?

[matpj]

I have a column containing a string of charactes that includes project code and project name.
If I create a new column, what formula can I use to trim the first 8 characters from this?

thanks,
Matt

 

[TonyJollans]

What about ..

[blue][tt] =RIGHT(A1,LEN(A1)-8)[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[matpj]

very good thinking.
thanks for that!!