close

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 ?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()