software

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 www.officekb.com

I would use Datagt;Filtergt;Autofilter and use customgt;begins with...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;mohd21uk via OfficeKB.comquot; lt;u20517@uwegt; wrote in message
news:5ede27c5beb13@uwe...
gt; In Column B I have certain values which start with GB2 e.g GB2-02210. I
gt; would
gt; to like to copy these values and paste it in another cell. I would like to
gt; do
gt; this with only values which start with GB2. Many thanks
gt;
gt; --
gt; Message posted via 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)=quot;GB2quot;;B2;quot;quot;)
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 (quot;quot;)
also the quot;GB2quot; argument can be replaced to a cell reference.. (like $C$1 lt;=
absolute reference)

Any good?

Best regards,
ANdras
(Hungary)

quot;Nick Hodgequot; wrote:

gt; I would use Datagt;Filtergt;Autofilter and use customgt;begins with...
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;mohd21uk via OfficeKB.comquot; lt;u20517@uwegt; wrote in message
gt; news:5ede27c5beb13@uwe...
gt; gt; In Column B I have certain values which start with GB2 e.g GB2-02210. I
gt; gt; would
gt; gt; to like to copy these values and paste it in another cell. I would like to
gt; gt; do
gt; gt; this with only values which start with GB2. Many thanks
gt; gt;
gt; gt; --
gt; gt; Message posted via www.officekb.com
gt;
gt;
gt;