I receive a worksheet daily from one of our outside companies. Because of
the way they have to get the information from their sources the data in one
of the columns is filled with alot of junk and I'm manually deleting the
information that's not needed. Each cells data is varied from one row to the
next. Is there a formula or feature in Excel that will remove all the
unwanted data? Sample data is included.

Cell C2 reads: 23477 1ea, 2489 1ea, 209667 1ea, 2096711 2ea, 79647 1ea.
Cell C3 reads: Item 694 ( Qty 2)<br 80022 (7)<br 209667 (2)<br <br

I don't need any of the letters nor parenthesis, brackets, commas,
etc...just the numbers...see example below

Cell C2 should read as: 23477 1 2489 1 209667 1 2096711 2 79647 1
Cell C3 should read as: 694 2 80022 7 209667 2

Any advice?

Rick