# Formula needed

#### agoodson56

##### Board Regular
How can I create a formule that will refect a worksheet title?

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### schielrn

##### Well-known Member
You can try:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Hope that helps.

#### Scott Huish

##### MrExcel MVP
=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

#### agoodson56

##### Board Regular
How would I make a formula that would show the tab name

#### schielrn

##### Well-known Member
That formula should show the tab name? Make sure you have saved the workbook for the formula to work.

#### Jonmo1

##### MrExcel MVP
I think the OP may have confused
Worksheet title and SHEET Name...

WorkBOOK title = Bookname.xls
WorkSHEET title = Tab Name

For WorkSHEET title - use formulas provided previously...

for WorkBOOK Title, (i'm sure there's something easier than this...)
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

#### Scott Huish

##### MrExcel MVP
The workbook does need to be saved first in order for these formulas to work. Save the workbook and then hit F9

Replies
2
Views
193
Replies
15
Views
425
Replies
4
Views
798
Replies
4
Views
162
Replies
5
Views
179

1,191,274
Messages
5,985,693
Members
439,974
Latest member
sjoerdbosch

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back