String Functions

J

JL

The function "instr" will find character in a string.
To answer your question,

lastname = Trim(Mid(FullName, 1, InStr(FullName, ",") - 1))
firstname = Trim(Mid(FullName, InStr(FullName, ",") + 1))

Hope this will help.
 

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 Export to PDF 0
type mismatch error in macro in excel 0
Removing Spaces at the End 2
Repeated call to InternetExplorer.Application seems to hang the PC 4
Outlook Userform Combobox Sort Code 0
Run time error in VBA Code 1
how do i separate an address field into three fields Access 2007 7
string manipulating function? 5

Top