Move first name to beginning
Folks,
I import data that gives me Last Name then First Name (space between the two names).
I need the format to be changed to First Name <space> Last Name
For example
Smith John
John Smith
I import data that gives me Last Name then First Name (space between the two names).
I need the format to be changed to First Name <space> Last Name
For example
Smith John
John Smith
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
appreciate it
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER