{"id":840,"date":"2021-10-06T02:58:22","date_gmt":"2021-10-06T02:58:22","guid":{"rendered":"https:\/\/lite14.net\/blog\/?p=840"},"modified":"2021-10-06T02:58:22","modified_gmt":"2021-10-06T02:58:22","slug":"how-to-get-a-phone-number-from-a-text-cell-in-excel","status":"publish","type":"post","link":"https:\/\/lite14.net\/blog\/2021\/10\/06\/how-to-get-a-phone-number-from-a-text-cell-in-excel\/","title":{"rendered":"How to get a phone number from a text cell in Excel"},"content":{"rendered":"

\"\"<\/p>\n

Adding contacts to your online messaging platform Message Box is simple. Simply add your customers’ mobile numbers to an Excel file and save it.<\/p>\n

If your CRM doesn’t let you export just mobile numbers, what do you do? What if you could download your customers’ data with their name, address, and phone number all in one cell? There are two ways to extract your customers’ mobile numbers into a single cell.<\/p>\n

Option 1 \u2013 Manually copy and paste each individual mobile number into a new cell.<\/p>\n

Option 2 \u2013 Read this post, use a simple formula, and complete this task in minutes, becoming an Excel wizard.<\/p>\n

Assuming you chose option 2, you only need one simple formula<\/p>\n

=MID(A1,FIND(\u201c07\u201d,A1,1),11)<\/p>\n

The formula above may appear complex to some, but it is not, and you do not need to understand it to extract your mobile numbers. Your data will be extracted in 4 simple steps if your mobile numbers do not contain spaces.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n