Steve Mackay

Posts: n/a

Thank you. Both of these functions work.
Steve Mackay

"ivano" wrote in message ...

Hy Steve,
try to a array formula (CTRL+SHIFT+ENTER):
=MID(CELL("filename"),LARGE(IF(MID(CELL("filename" ),seq,1)="\",seq,""),2)+1,
SEARCH("]",CELL("filename"))-LARGE(IF(MID(CELL("filename"),seq,1)="\",seq,""
),2))

After you have defined "seq" as:
=ROW(INDIRECT("1:1024"))

ivano

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
working folder	David	Excel Discussion (Misc queries)	1	January 10th 05 08:52 PM
The available macros list in XL; how to suppress filename from showing	KR	Excel Discussion (Misc queries)	1	January 10th 05 07:20 PM
How can I change the appearance of the folder icon	Margie	Excel Discussion (Misc queries)	4	December 29th 04 02:41 PM
How do i save backup copy in a different folder	mekraj	Excel Discussion (Misc queries)	3	December 17th 04 08:33 PM
cannot save file - folder is read only	BigDog	Excel Discussion (Misc queries)	1	December 7th 04 11:18 PM

All times are GMT +1. The time now is 12:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us