Hi,

Basically, what I need to accomplish is this:

I have ran a web query with excel 2003, and the site I ran this query
on gave me result like this:

In one row of the workbook, I have:

_PRODUCT_ID_:

0001
Item #:
0002
Item #:
0003 ID:
Item #:

What I need to do is remove the cells that say Item #: and then shift
the cells up so that the item numbers are the only ones in that row and
no spaces between them.

Thanks alot for your help in advance!
-Brian


--
Brian07002
------------------------------------------------------------------------
Brian07002's Profile: http://www.excelforum.com/member.php...o&userid=15915
View this thread: http://www.excelforum.com/showthread...hreadid=385676