How to find common string combination in strings

[Rasm]

I have 3 columns headers - so each ther own

1) Header1_Device1 (Col A)
2) Header2_Device1 (Col B)
3) Header3_Device1 (Col C)

How can I find the common string combination - essentially I want to write a macro to devide the header into 2 rows instead of one row - then merger the cells for the common part. so my header would now be

Row 1 ---- Device1 (This would be a merged cell)
Row 2 ------ Header1 & header2 & Header3 (This would still be 3 separate columns)

 

[Rasm]

PGC01

ok - I have now managed to get myself real confused - I tried to set up an example for you manually - but the logic is inconsistent. So I will try you code - but I think what I am trying to do is nonsense. If I need more help - I will be back - sorry to make you work - when I dont have my thoughts structured.

 

[pgc01]

I agree, that's a good thing. When things are not clear it's good to stop, step back and rethink the approach.