In Column B I have certain values which start with GB2 e.g GB2-02210. I would
to like to copy these values and paste it in another cell. I would like to do
this with only values which start with GB2. Many thanks

--
Message posted via http://www.officekb.com

I would use DataFilterAutofilter and use custombegins with...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"mohd21uk via OfficeKB.com" <u20517@uwe wrote in message
news:5ede27c5beb13@uwe...
In Column B I have certain values which start with GB2 e.g GB2-02210. I
would
to like to copy these values and paste it in another cell. I would like to
do
this with only values which start with GB2. Many thanks

--
Message posted via http://www.officekb.com

Hi there,

you also can show (the result of the function will be) the value, like in an
additional column, e.g.
=IF(LEFT(B2;3)="GB2";B2;"")
where in B2 the cell with the value (starting or not-starting with GB2)
and then copy the function downwards to fill this column

if the value starts with GB2; then will reveal the result, if not, will be
blank ("")
also the "GB2" argument can be replaced to a cell reference.. (like $C$1 <=
absolute reference)

Any good?

Best regards,
ANdras
(Hungary)

"Nick Hodge" wrote:

I would use DataFilterAutofilter and use custombegins with...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"mohd21uk via OfficeKB.com" <u20517@uwe wrote in message
news:5ede27c5beb13@uwe...
In Column B I have certain values which start with GB2 e.g GB2-02210. I
would
to like to copy these values and paste it in another cell. I would like to
do
this with only values which start with GB2. Many thanks

--
Message posted via http://www.officekb.com