Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract a foldername with a formula-update formula does not work
hello,
=left.,. The formula is incomplete, i must extract different filename's E.G. c:\program files\eag\dir\testing\test.xls Now the formula must extract c:\program files\eag\dir\ another example: c:\windows\system\systemroot\test\testing.xls The formula must extract c:\windows\system\systemroot\ So you can see, the formula must extract the file and its folder, so 2 steps I can't get it to work, hope you can Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract a foldername with a formula-update formula does not work
=Left(B102,len(B102)-len(cell with your formula that extracted the
filename)) -- Regards, Tom Ogilvy "solo_razor" wrote in message ... hello, =left.,. The formula is incomplete, i must extract different filename's E.G. c:\program files\eag\dir\testing\test.xls Now the formula must extract c:\program files\eag\dir\ another example: c:\windows\system\systemroot\test\testing.xls The formula must extract c:\windows\system\systemroot\ So you can see, the formula must extract the file and its folder, so 2 steps I can't get it to work, hope you can Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract a foldername with a formula-update formula does not work
I'm not sure which you wanted:
f="c:\program files\eag\dir\testing\test.xls" mid$(f,1,WorksheetFunction.Find(chr$(22),Worksheet Function.Substitute(f,"\",chr$(22),len(f)-len(join(split(f,"\"),""))-1))) or f="c:\program files\eag\dir\testing\test.xls" mid$(f,WorksheetFunction.Find(chr$(22),WorksheetFu nction.Substitute(f,"\",chr$(22),len(f)-len(join(split(f,"\"),""))-1))) solo_razor wrote in message ... hello, =left.,. The formula is incomplete, i must extract different filename's E.G. c:\program files\eag\dir\testing\test.xls Now the formula must extract c:\program files\eag\dir\ another example: c:\windows\system\systemroot\test\testing.xls The formula must extract c:\windows\system\systemroot\ So you can see, the formula must extract the file and its folder, so 2 steps I can't get it to work, hope you can Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
update formula in column when another cell formula is changed | Excel Worksheet Functions | |||
extract a foldername with a formula | Excel Programming |