Hi all. I was hoping the collective brain power in here is better than mine right now.
I have a column of strings. In each string there will be anywhere from one to three four-digit numbers separated by something, but it is not always the same thing. The numbers are also not in the same place.
For example:
A1: blah blah 1234 blah 5678
A2: blah 9876
A3: blah blah blah..1234 blah
A4: blah, 4554 9977
Does anyone have any suggestions on how to pull out the four digit numbers? VBA is preferable.
Cheers