Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cathy Spencer   on Dec 31 In MS Office Category.

  
Question Answered By: Adelfrid Fischer   on Dec 31

I do a bit of this all the time because some of my "clients" like to alter
the names of worksheets. Being in a multi language environment has it's
ummmm drawbacks :-)

I reflect the name of the sheet  in cell  A1 so if the sheet is printed the
name is there as the user has altered it in nice big letters.

I don't think it's completely what you are looking for but maybe a pointer.

The formual I use is....

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

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Excel Function Or get search suggestion and latest updates.


Tagged: