Display a sting of consecutive numers, then the rest

Hello all. This is my first post and I'm looking for some assistance. I need to take data in this format (1) (2) (3) (4) (5) (6) (7) (8) (10) (13) (16) (18) and display it in this format (1-8), (10) (13) (16) (18).

Thank you. Your assistance is greatly appreciated.

Is each number in a different cell? Can you upload an excel file with the data as you currently have it? Do you only need to do this once with these numbers? Or will the numbers change?

Hi there,

if I understand you correctly (which I might not) the formula to reformat 1-8 will be this: =IF(LEN(D4:K4=8),CONCATENATE(D4,"-",K4),"")

The other formulas for 10,13,16,18 will look like this: =IF(D6<>"",L4). I have created a spreadsheet to better demonstrate how these might work for you, and uploaded it to this reply.

Hope this helps.

Oscar.

Yes! So the formula in place now references data from another sheet and concatenates it. I need to combine the formula that is in place now with the formula that Oscar provided. The current formula is: =IFERROR(IF(VLOOKUP(D8,[workbook_name]sheet_name!$H:$I,1)<>D8,"",VLOOKUP(D8,[workbook_name]sheet_name!$H:$I,2)),"")