Delete first few cell characters

[mohd21uk via OfficeKB.com]

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

[penri0_0]

You could use =RIGHT(A1,9), where A1 is the cell containing your original data. This will pick up the last 9 digits.........only works if your original text strings are identical in length though.

HTH

[Roger Govier]

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@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

[Gilles Desjardins]

Data, text to column, delimited, space, finish should do the trick IF there
is a space between ALL your values.
To do this just highlight the column that contains your values then start at
the menu called data then follow my instructions word for word in the first
line above.

HTH
Gilles
"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

[David Biddulph]

"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