I have a column filled with cells that have the name of a company with one open parenthesis and then the ticker- the ticker could be three or four letters and there is no closed parenthesis.
For example:
Advanced Enerfy Industries (AEIS
amerrsxo, Inc. (AGFS
How can I create a column with just the ticker itself?
I thought of using the mid function but haven’t gotten it to work.
Thank you!
Bookmarks