By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

expertatexcel.com

 


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