By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes
948 Steps to 6 Figures by Learning Excel-VBA and Other Skills
Step 711 - FixName - takes a passed name in Last, First and changes to First Last
This function is useful for generating emails and learning some basic coding techniques.
Function FixName(s)
lComma = Instr(s, ",")
If Instr(s,",") > 0 then
FixName = Mid(s, lcomma + 2) & " " & Left(s, lcomma - 1)
else
FixName = s
End If
End Function