Hello,



I looked all over the internet to find a way to collapse a string of data WITHIN a cell and I got only search results that show how to collapse and expand rows in Excel 2007 (which is NOT what I'm looking for).

I have a problem when importing a Bill Of Material from MS Excel 2007 into Any system. The issue is the cell data gets truncated where the reference designators are when there are hundreds of them

For example
R1, R2, R3, R6, R8, R9...R309, R310...

Import into any system only sees: R1, R2, R3, R6, R8, R9...R30

Bill Of Material initially saved as .XLS. I tried importing this file and didn't work as shown ex. above. After running MACRO (which MACRO does not work in Excel 2007 .XLSX file, only in .XLS), I saved file in .XLSX and then tried importing and same error. Then I tried copy from XLS. then paste as values in .XLSX and still same error.

Finally, I have an idea but don't know how to do this. I want to collapse reference designators into ranges WITHIN CELL like this (to save character space in cell):

R1, R2, R3, R6, R8, R9...R309, R310... --> R1-R3, R6, R9...R309-R310, etc.

How do I do this please?