I have some text in cell C2 that looks like this: clonidine_Area
I want to copy the text before the underscore and paste it to another cell.
I've gotten this far but don't know how to proceed... How do I use the position number to selectively copy the string that I want? Any help would be...