ASKER
Would it still be "test", and therefore you want to take everything from the LEFT up to and including the string entered in the prompt?
ASKER
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY
Can you explain a bit more about the new "right to left" option? In the case of your example file that you attached, what string would you have entered to produce the results you want in column C? Would it still be "test", and therefore you want to take everything from the LEFT up to and including the string entered in the prompt? Or something else?
»bp