Okay, I have one column full of Item #s and Descriptions. I have another column that I want JUST the Item# in it.

For example:

Column 1:
Gyroscope REF#1234 Bike Thing

Column 2 Should Be:
1234

Column 1:
BallWall Bikes Ret# 12456 Helmet Thing

Column 2S hould Be:
12456

I don't know how to do this (I do know how to do VBA mildly, and I am pretty good with formulas). I also have a database of every Item# that could be in that cell.