Excel: Extract Mobile Numbers from data

Hi, I have a huge data sheet and under column titled Cust. Contact details: Postal address of customer along with his / her email IDs, (some times more than 2 or 3) and also their mobile number and landline number are given. 1. I need to extract ONLY the mobile numbers in the cells adjacent to this column. 2. I need to collate all these mobile numbers obtained in this column of point 1 above into one cell. Looking forward to help. Rgds, Rizvi

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

This thread is current as of April 13, 2017.

For more resources for Microsoft Excel