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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I group numbers in a list based on contiguous/missing? (https://www.excelbanter.com/excel-worksheet-functions/192859-how-do-i-group-numbers-list-based-contiguous-missing.html)

Lyndi

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

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?

Jarek Kujawa[_2_]

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

did you mean that?

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

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

All times are GMT +1. The time now is 02:15 AM.