Copy cell to a new cell

[mohd21uk via OfficeKB.com]

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

[Nick Hodge]

I would use Data>Filter>Autofilter and use custom>begins with...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]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

[ANdras]

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 Data>Filter>Autofilter and use custom>begins with...
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> [email protected]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
>
>
>