Recently, I had to pull customer numbers out of strings from an excel sheet. Sure, you can use trickery like spaces to columns or regex. Excel is pretty powerful, if you know all of the text tools at your disposal. This is how I extracted the numbers for random text
The problem was, each row was formatted differently. So I had several thousand rows that looked like this:
Client A (555)
Client B (789) Houston
Client Dallas (4444)
and so on.
I looked around on some Excel Guru sites and found the following formula.
Though not perfect, this was exactly what I needed. The one drawback to this code is any cell with non sequential numbers such as:
Client T1000 Loop 360
will not work.