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