Extracting data between two commas (1 Viewer)

miacino

Registered User.
Local time
Today, 13:11
Joined
Jun 5, 2007
Messages
106
I've used left and mid strings before, but someone can't get a handle on this one!

DOE, JANE, MD

I'm trying to just get the first name (Jane) (the text between the two commas).

Any help would be appreciated! :banghead:
 

June7

AWF VIP
Local time
Today, 12:11
Joined
Mar 9, 2014
Messages
5,423
Will there always be 2 commas?

Mid(x, InStr(x,",")+2, InStrRev(x,",")-InStr(x,",")-2)
 

Users who are viewing this thread

Top Bottom