| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
FIND formula that searches from right?
I'd like to create a formula for pulling the file name off of a string that
contains the full file path. It would be great if there was a FIND type formula that searches from right to left, then I could search for the last "\" and take everything to the right of it. Also, my file paths aren't consistent. The number of subfolders will change. Suggestions? KDB |
|
#2
|
|||
|
|||
|
One way
http://tinyurl.com/5ou3r Regards, Peo Sjoblom "KellyB" wrote: I'd like to create a formula for pulling the file name off of a string that contains the full file path. It would be great if there was a FIND type formula that searches from right to left, then I could search for the last "\" and take everything to the right of it. Also, my file paths aren't consistent. The number of subfolders will change. Suggestions? KDB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find information between 2 dates | Excel Worksheet Functions | |||
| I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| Can you help to find the right formula? | Excel Worksheet Functions | |||
Linear Mode
