InStrRev function help

B

Bobby Bosxo

After looking at the MID function I had one of those
moments when reality took over. I got it working and just
in case someone else needs it...

Lastname: Mid$([IDWFullName],(InStr(1,[IDWFullName],". ")
+2),((InStrRev([idwfullname],",",-1)-(InStr(1,
[IDWFullName],". ")+2))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
VBA Export to PDF 0
type mismatch error in macro in excel 0
Converting URLs in comments to Markdown-formatted links 2
Access 2007,reports,VBA 2
Auto increment by one letter 1
Split Name 2
Excel - Wich Function should I use? 1

Top