cell value to be same as tab name

marcs

Active Member
Joined
May 3, 2005
Messages
420
I'm wondering how to cause a particular cell to always have the same value as the ws. tab name

help most appreciated.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,088
Office Version
  1. 365
Platform
  1. Windows
Here's one example, I'm sure there are many other's.

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

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,308
Members
412,716
Latest member
thviid
Top