Hi,
Thanks for taking the time to see if you can help.
In one column, I have doctor's names (Dr. P. Schwarts, license #...., etc.) and (Dr. S. L. Jenson, license #....etc.). As you can see, some have one initial and some have two. What I
really need to do is extract the doctor's name BEFORE the "," which lists the doc's license and other information.
What I have:
COLUMN A
Dr. P. Schwarts, license #
Dr. S. L. Jenson, license #
What I need
COLUMN B
Dr. P. Schwarts
Dr. S. L. Jenson
What would be the proper formula for this to happen?
Thank you.![]()
Bookmarks