I have a macro that I'm using to check people in based on their name. The only problem is that the names are both First Last; Last, First; some have middle initials and others have Jr, Sr, etc. I know that this can be sorted through using a Regular Expression, but I have no clue how they operate. I've found many an example of Regular Expressions for VBA, but none of them translate into "Proper English". Is there anyone who can assist?
Last edited by bobo6429; 05-18-2009 at 03:06 PM.
"It's all fun and games until someone loses an eye. Then it's just one big game of Find The Eye!" -M. Keefer
Bump no responce.
Assist with what? I don't see an actual specific question.... I don't see the macro.... I don't see an attached sample workbook showing your need/goal.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sorry. I figured it out on my own, and I'm not sure how to delete my own thread.
Glad to hear it. It would be interesting to know what you were actually referring to, as well as your homegrown solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks