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 268 - Convert a Name from Last, First to First Last

Problem

You have a name that is in last, first format (ex. Berg, Al) and need to convert it to First Last format.

Solution

Instr - find a string within a string

& - Concatenation

Function -

Mid - Extract data from a string

Write a function