Hi,

I'm not sure what you mean by 'in a header' but to display the 7 leftmost
characters of your worksheet name try this

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,7)

Adjust the last number 7 to display more or less characters

Mike

"AsquareDC" wrote:

i want to only show a part of the worksheet tab name in header. for e.g, I
have my worksheet named Annex I - Buildings but I want only Annex I to be
displayed.

How do I do that?