Excel: Extract 7 digit number from email subject

Hi, I have imported email subject lines to excel. For ex - FW: 04.15.14 - THE MANHATTAN HOTEL ROTTERDAM BID #: 8399 / GDS CAMPAIGN #: 3672287 SABRE GPS DRU I need to extract the 7 digit numbers i.e. 3672287 to the next cell from eah subject line. Please note that these numbers are not at the same place. Any Macro or formulae will be appreciated. Regards, Ravi

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of April 16, 2014.

For more resources for Microsoft Excel