How to get just file name on a cell without .xls extenion ?
=MID(CELL(quot;filenamequot;,A1),FIND(quot;[quot;,CELL(quot;filenamequot;,A1)) 1,FIND(quot;]quot;,
CELL(quot;filenamequot;,A1))-FIND(quot;[quot;,CELL(quot;filenamequot;,A1))-5)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com
quot;UNNIquot; gt; wrote in message
...
gt; How to get just file name on a cell without .xls extenion ?
See www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;UNNIquot; gt; wrote in message
...
gt; How to get just file name on a cell without .xls extenion ?
- Sep 29 Fri 2006 20:09
How to get file name on a worksheet?
close
全站熱搜
留言列表
發表留言