Thread: Delete first few cell characters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mohd21uk via OfficeKB.com
 
Posts: n/a
Default Delete first few cell characters
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
Reply With QuoteReply With Quote