software

Thanks for the formula. I tried to copy and paste into a cell and Excel
advised the formula contained an error, highlighting the the following
portion:

CELL(quot;filenamequot;

Did I do something wrong?quot;JudithJubileequot; wrote:

gt; Hello sdmccabe,
gt;
gt; Type the following formula:
gt;
gt; =RIGHT(CELL(quot;filenamequot;,A1),LEN(CELL(quot;filenamequot;,A1) )-FIND(quot;]quot;,CELLquot;filenamequot;,A1),1))
gt;
gt; Exactly as is written but on 1 line
gt;
gt; Judith
gt; --
gt; Hope this helps
gt;
gt;
gt; quot;sdmccabequot; wrote:
gt;
gt; gt; Can I display the name of a tab in a given cell?=RIGHT(CELL(quot;filenamequot;,A1),LEN(CELL(quot;filenamequot;,A1) )-FIND(quot;]quot;,CELL(quot;filenamequot;,A1),1))

The formula above should all be on one line.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;sdmccabequot; wrote:

gt; Thanks for the formula. I tried to copy and paste into a cell and Excel
gt; advised the formula contained an error, highlighting the the following
gt; portion:
gt;
gt; CELL(quot;filenamequot;
gt;
gt; Did I do something wrong?
gt;
gt;
gt; quot;JudithJubileequot; wrote:
gt;
gt; gt; Hello sdmccabe,
gt; gt;
gt; gt; Type the following formula:
gt; gt;
gt; gt; =RIGHT(CELL(quot;filenamequot;,A1),LEN(CELL(quot;filenamequot;,A1) )-FIND(quot;]quot;,CELLquot;filenamequot;,A1),1))
gt; gt;
gt; gt; Exactly as is written but on 1 line
gt; gt;
gt; gt; Judith
gt; gt; --
gt; gt; Hope this helps
gt; gt;
gt; gt;
gt; gt; quot;sdmccabequot; wrote:
gt; gt;
gt; gt; gt; Can I display the name of a tab in a given cell?
gt;