I'm looking for a formula that can pull out numbers from a text field.

In Some of the text fields the numbers are preceeded by a "#" sign. In others they are not. The numbers are all different lengths and can be at the begining, middle, or end.

example of "#" sign one is "Pkg Lot/Bldg #1215"

example of no sign one is "Pkg Lot/bldg 1215"