I have an excel spreadsheet that has the following type of data in the cells:
"11/09/08 20:29 JDS David/DBLD reports lights in the canopy are not working Christine/CBRE b4957204-1"
I need to know if there is a way to mine the B4957204-1 out of this, I have 300 cells with similiar text in that I need just a list of call #'s out of without all the other dribble. Any suggestions?
Bookmarks