How to sort cells in a column that contain the pattern XXX-XXX-XXXX

rlouderback

New Member
Joined
Jul 19, 2018
Messages
2
I have a long list of contact information that I'd like to sort by ones that have a phone number in the name column. An example:

Bob Johnson
Joe WALMART
John Smith 555-555-5555

There are numerous entries but I'm trying to sort a column so I can group the entries that have a phone number like John Smith's does above. Not all cells contain names, some contain company names or any random nouns, but the cells with phone numbers are all in the 555-555-5555 format.
Thanks for any help.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Is the phone number ALWAYS the last part of the cell or could it appear anywhere?
 
Upvote 0
50 out of 11,000 entries are in a different format, but the rest of the cells with phone numbers will have them as the last part of the cell. Once I figure out how to group them, I'll be using the RIGHT formula to send the phone numbers to the cells I want them in.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,254
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top