ravikabadwal
New Member
- Joined
- Apr 16, 2014
- Messages
- 10
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
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