Reverse First and Last Names in Excel. http://www.contextures.com/excelsplitnames.html#reverse Visit this page to download the sample file for this video.
Use a formula in Excel to reverse the order of names in a cell. Change from Last Name, First Name to First Name Last Name.
00:18 View the Formula
00:40 Find the Comma
01:13 Formula for Comma
02:34 Get the Last Name Length
03:01 Get the Last Name
03:43 Add a Space
04:25 Begin the First Name Formula
05:52 How to Calculate Length of First Name
06:41 Formula for First Name Length
07:03 Get Space Position
07:27 Length of First Name
08:05 Review the Formula
08:42 Get the Sample File
Watch this video to see how to create the formula to pull the first name and last names from a list of names, and put a space character between them.
Tags: Reverse First and Last Names in Excel, Excel, #mstips, Excel formula, Excel reverse names, Excel first name, Excel first and last name, Excel LEN function, Excel RIGHT function, Excel LEFT function, Excel SEARCH function, Contextures, Dalgleish, Debra Dalgleish, Microsoft Excel (Software)