Thread
:
Cell function
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Chris
external usenet poster
Posts: 788
Cell function
I'm trying to reference the sheet name of the workbook I'm using.
When I type =Cell("filename") into a cell I get this,
C:\documents and settings\chris\desktop\test.xls
How do I extract just the word test(without the .xls)?
Reply With Quote
Chris
View Public Profile
Find all posts by Chris