P
pameluh
For example... the tab name is Apples. I want cell A1 to say Apples
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
B
Biff
Just to add.....
The file must already exist. It must have been saved and given a name.
Biff
The file must already exist. It must have been saved and given a name.
Biff
Gary''s Student said:=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary's Student
pameluh said:For example... the tab name is Apples. I want cell A1 to say Apples
T
Tom Ogilvy
The file must already exist. It must have been saved and given a name.
Another way to say this is:
The file must have been previously saved for this to work.
--
Regards,
Tom Ogilvy
Another way to say this is:
The file must have been previously saved for this to work.
--
Regards,
Tom Ogilvy
Biff said:Just to add.....
The file must already exist. It must have been saved and given a name.
Biff
Gary''s Student said:=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary's Student
pameluh said:For example... the tab name is Apples. I want cell A1 to say Apples
P
pameluh
Brilliant! Thanks guys! You just made me a hero! Much appreciated!