Q qwang1115 Registered User. Local time Today, 06:12 Joined Oct 24, 2008 Messages 14 Jan 8, 2009 #1 I have a field called Full Name and data looks like this: Mary Smith Mary S. Smith Mary S Smith I only need the last name. Please give me some hints. Thanks!
I have a field called Full Name and data looks like this: Mary Smith Mary S. Smith Mary S Smith I only need the last name. Please give me some hints. Thanks!
pbaldy Wino Moderator Staff member Local time Today, 06:12 Joined Aug 30, 2003 Messages 36,272 Jan 8, 2009 #2 Try the Mid() function with the InStrRev() function inside that to find the position of the last space.
Try the Mid() function with the InStrRev() function inside that to find the position of the last space.
Q qwang1115 Registered User. Local time Today, 06:12 Joined Oct 24, 2008 Messages 14 Jan 14, 2009 #3 pbaldy said: Try the Mid() function with the InStrRev() function inside that to find the position of the last space. Click to expand... Thanks you so much for your help!
pbaldy said: Try the Mid() function with the InStrRev() function inside that to find the position of the last space. Click to expand... Thanks you so much for your help!
