Hi,
how can we get the last values from
E:\data\london\test.pdf
we want only with the formula = test.pdf
Hi,
how can we get the last values from
E:\data\london\test.pdf
we want only with the formula = test.pdf
Hi, in VBA (macro?) or in a formula?
in a macro assuming your string is in column a
In a formula, that's not my strongPlease Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Please try
=trim(right(substitute(a1,"\",rept(" ",20)),20))
More alternatives, assuming pathname in cell B2.
Formula:Please Login or Register to view this content.
If there'd be a lot of such formulas, better to define a name like seq referring to =ROW(INDEX(Sheet1!$1:$1048576,1,1):INDEX(Sheet1!$1:$1048576,255,1)), then use
Formula:Please Login or Register to view this content.
which is an array formula, so need to hold down [Ctrl] and [Shift] keys before pressing [Enter] to enter it.
Picky Tangent: filename could have multiple adjacent spaces, e.g.,
Rare, certainly, but TRIM could screw up such base filenames.Please Login or Register to view this content.
Thanks Bo_Ry,
its working
thanks hrlngrv,
its working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks