How do I group numbers in a list based on contiguous/missing?

's Computer Specifications

I have a list of phone numbers that I need to break into contiguous ranges,
i.e.; 2372-2385, 2389-2402. Is there a way to do this with a function?

's Computer Specifications

did you mean that?

=LEFT(A1,FIND("-",A1)-1)

=RIGHT(A1,LEN(A1)-FIND("-",A1))

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do i group the mails based on the numbers in the subject line	Subramanian	Microsoft Outlook VBA Programming	1	15th Mar 2010 01:05 PM
Text for numbers in option group AND filter based on previous list box	Annemarie	Microsoft Access Form Coding	6	22nd Dec 2006 05:57 PM
ad-based group policy missing item	=?Utf-8?B?Q1kgUGFuZw==?=	Microsoft Windows 2000 Group Policy	2	10th Aug 2006 10:14 AM
Missing Query-based group in ADSIEdit	Mike	Microsoft Windows 2000 Active Directory	1	11th May 2006 02:47 AM
List Containing Instances of Numbers in a group	MrvinGover	Microsoft Excel Worksheet Functions	2	20th Jan 2004 09:45 PM