Copy part of worksheet name to cell

[Blunder1]

Hi,

In my code it runs through 242 worksheets in a workbook. When it runs through i need to copy part of the worksheet name (all text after '-') to a cell. For example, sheet 1 is named '301 - FO Volume', i need to copy to cell k1 'Fo Volume' only.

Thanks in advance

Blunder

 

[Joe4]

Enter this formula in K1:
=TRIM(MID(CELL("filename",A1),FIND("-",CELL("filename",A1))+1,LEN(CELL("filename",A1))))

 

[Blunder1]

Works like a charm! Thank you joe4

Blunder1