Hi
Try
Assuming data is in column A
=MID(A1,FIND(" ",A1)+1,255)
Copy down as far as required.
Copy block of results and Paste SpecialValues to "fix" as opposed to
leaving as formulae
--
Regards
Roger Govier
"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.
Many Thanks,
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1