ExcelBanter - formula for tab value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula for tab value (https://www.excelbanter.com/excel-discussion-misc-queries/165124-formula-tab-value.html)

Alylia

formula for tab value

i want to show in a cell what is in the tab on the worksheet. please advise
how do i go about that.

Gary''s Student

formula for tab value

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary''s Student - gsnu200754

"Alylia" wrote:

i want to show in a cell what is in the tab on the worksheet. please advise
how do i go about that.

All times are GMT +1. The time now is 06:12 AM.