Re: Delete first few cell characters

Tech-Archive recommends: Speed Up your PC by fixing your registry

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


.

Relevant Pages

  • Re: Alt + click should not be used to start research pane. I want to .
    ... I have no trouble Alt+dragging to select a column. ... The trick is to ... Word MVP FAQ site: http://word.mvps.org ... I frequently want to highlight a column of text, ...
    (microsoft.public.word.docmanagement)
  • Re: outlook xp
    ... font would do the trick. ... Alias ... if i highlight the words that are underlined, it will not let me undo ...
    (microsoft.public.office.misc)
  • RE: How do I highlight cells for use but not print the highlights?
    ... trick. ... "MCK" wrote: ... > so that they do not forget to populate those cells. ... > allows me to highlight the cell, but then removes the highlighting when ...
    (microsoft.public.excel.misc)
  • Re: Date Functions
    ... Thank you for your help but your suggestion, unfortunately didn't do the trick. ... "Myrna Larson" wrote: ... > highlight any date a year or more prior to today's date? ...
    (microsoft.public.excel.worksheet.functions)