Re: Delete first few cell characters
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Jun 2006 11:54:11 +0100
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 Special>Values to "fix" as opposed to
leaving as formulae
--
Regards
Roger Govier
"mohd21uk via OfficeKB.com" <u20517@uwe> wrote in message
news:61698ffe1b1de@xxxxxx
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.aspx/ms-excel/200606/1
.
- References:
- Delete first few cell characters
- From: mohd21uk via OfficeKB.com
- Delete first few cell characters
- Prev by Date: Re: Delete first few cell characters
- Next by Date: Re: Sumproduct Query
- Previous by thread: Re: Delete first few cell characters
- Next by thread: Re: Delete first few cell characters
- Index(es):
Relevant Pages
|
