in this string, all is working, it returns 32.
but when i run this:
Please Login or Register to view this content.
this string SHOULD return 8 right? but it doesnt, it returns a value of 3. Why is that so? i find it very unususual and i cannot find a solution to this!Please Login or Register to view this content.
INSTRREV started from the end of the string and found the second "the", but it counted from left to right to the 32nd position.
INSTRREV started from the end of the string and found "/" and counted from left to right to the 3rd position.
INSTR finds the first occurrence of x, INSTRREV finds the last, there were two "the"'s but only one "/".
Last edited by protonLeah; 10-09-2013 at 03:53 PM.
Ben Van Johnson
So by that rationale the only way to return 8 is:
???Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks