The result should be same as InstrRev , but I want to use excel function FIND .
Because I want to use FIND function in a formula for a range, I believe that below code finds first occurrence of character, which is not what I want. I want a excel function finding last occurence.
Thanks.
Please Login or Register to view this content.
Last edited by VAer; 10-20-2021 at 01:54 PM.
See: https://www.exceltactics.com/reverse...el-using-find/
That gives you the basics, then see page 2 for what you want: https://www.exceltactics.com/reverse...-using-find/2/
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks. I have solved the issue earlier from this link: https://trumpexcel.com/find-characters-last-position/
Shame you didn't share your solution sooner then
Sorry, I was working. Meeting and something, busy, if you did not reply, I would not come back to this post till tonight. The question is just a few hours ago, not long ago, I just solved it less than 2 hours ago.Originally Posted by TMS
Shame you didn't share your solution sooner then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks