Excel, Access, PowerPoint and Word Help > Forum > Zone of the Champions > Rick Rothstein's Corner > Reversing a "First Middle Last" Name to "Last, First Middle" Name Format If this is your first visit, be sure to check out the FAQ by clicking the link above. Here is a solution with one single cell formula (without using VBA). You will have to press ctrl+shift+enter because this is an array formula. This will work with all strings similar to format: * abc xyz pqr -> abc pqr * abc xyz lmn pqr -> abc pq...

To extract the first, middle and last name we use the formulas "LEFT", "RIGHT", "MID", "LEN", and "SEARCH" in Excel. LEFT: Returns the first character(s) in a text string based on the number of characters specified. Jul 27, 2010 · To extract the first name after the comma from A1, use one of the following formula: =MID(A1,FIND(",",A1)+2,256)