"mohd21uk via OfficeKB.com" <u20517@uwe wrote in message
news:61698ffe1b1de@uwe...
I have values in a column where the cell values are like the following. I
would like to delete the first few characters until a G is reached. For
e.g.
I would like :
PRJ GB2-E0001
WBS GB2-E0001
to be converted to:
GB2-E0001
GB2-E0001

I would be grateful if you could provide me the code to do just this.

=RIGHT(A1,LEN(A1)+1-FIND("G",A1))
--
David Biddulph