Quick Little Function Help...

[Brian07002]

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

 

[Ron Coderre]

Here are 2 ways to do this:

Easiest:
1)Sort the list. (all the "Item #:" will goup together)
2)Select the "Item #:" rows and delete them
Done (but you lose the original order)

OR

Data>Filter>AutoFilter
Product ID dropdown, select "Item #:"

Then
select the displayed "Item #:" rows (all at once)
Edit>GoTo>[Special...]> Visible Cells Only
Edit>Delete>Entire Row
Data>Filter>Show All
Done

Does that help?

Ron

 

[Brian07002]

Hi,

Thank you so much! It worked great!

-Brian