Parsing out a string portion by case change

I'm not sure of a way to test for Case in a formula. If you can use VBA (macros) in your file, and your list is in column A without a header row, you can use the below code. It will put the results in columns B and C.

1. Right click on the sheet tab and click "View Code"
2. Paste the below code into the window that appears.
3. In the Tools menu, click "references"
4. Scroll down to "Microsoft VBScript Regular Expressions 5.5" and check the box for it and then click OK.
5. Put your cursor somewhere in the code you pasted and press "F5" to run the macro.

Please Login or Register  to view this content.

Dan

Hi and welcome to the forum,

See if my User Defined Function is a little easier to understand and works for you.

See the attached.