Anthony Chilco wrote at 15:31 on 9 May 2006: > Hi James, > The simplest solution may be to write a basic function that returns the > filename from the cell contents. In the function, you could scan the > string backwards starting with the character at the 'string length' > position and look for a period, then continue until you find a backslash > or colon. > tc
Thank you Anthony. I take it from the fact that neither you nor Dennis has told me how to search (find?) from right to left without using Basic that such is not possible. Oh, well ..... As I stated in my original post, I don't want to use Basic since this may also be used in Excel and the two versions of Basic are said to be different enough to prevent cross usage. -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
