backwards find function to find character in a string of text
Hello All,
I'm having a problem doing something that seems like it would be relatively simple....I have a value in a cell which is actually the directory path and name of another workbook (i.e. \\Server1\clients\clientA\financials\financialstat ement.xls) and I would like to get just the file name by itself. The name "financialstatements" will vary, so I will need a function/macro that can take whatever is between the last "\" and ".xls" and return that value to a cell. I have been unable to use the right function with the find function because the find function starts at the beginning of the string and therefore returns the first "\". Is there a way to start from the end of the string instead of the beginning? Thanks in advance, Ashleigh |
backwards find function to find character in a string of text
Ashleigh,
In Excel 2000 and later, you can use the InStrRev function to search right to left. E.g., Dim Pos As Long Pos = InStrRev(S, "\", -1, vbTextCompare) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ashleigh K." wrote in message ... Hello All, I'm having a problem doing something that seems like it would be relatively simple....I have a value in a cell which is actually the directory path and name of another workbook (i.e. \\Server1\clients\clientA\financials\financialstat ement.xls) and I would like to get just the file name by itself. The name "financialstatements" will vary, so I will need a function/macro that can take whatever is between the last "\" and ".xls" and return that value to a cell. I have been unable to use the right function with the find function because the find function starts at the beginning of the string and therefore returns the first "\". Is there a way to start from the end of the string instead of the beginning? Thanks in advance, Ashleigh |
All times are GMT +1. The time now is 06:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com