We can use one of Excels formulas to flip the first and last name quickly in a column with following steps.

Last names for space. Right-click the column header to the right of the names you wish to split and select Insert. Alexander Gerst Soyuz TMA-13M. Dale Gardner 19482014 STS-8 STS-51-A.

Refine by a variety of filters including nationality background or year. Marc Garneau STS-41-G STS-77 STS-97. Find the Perfect Last Name.

Flip the first and last name in a column with a function. The last name starts at the sixth character from the left A and ends at the eleventh character the second space. So depending on how your data is stored you have now extracted either the first name or the last name.

Since 1945 NACA NASAs predecessor and since 1958 NASA have conducted the X-Plane Program. This formula involves nesting SEARCH to find the positions of the spaces. On the Excel Ribbon click the Data tab.

Guy Gardner STS-27 STS-35. And then drag the fill handle down to the cells to apply this formula then you can see all first and last names have been revered. The first X-Plane the Bell X-1 was the first rocket-powered airplane to break the sound barrier on October 14 1947.

Then you supply the above number to the RIGHT function instructing it to pull that number of characters from the end of the string. It seems people dismiss this choice because their data is already in columns. Michael Gernhardt STS-69 STS-83 STS-94 STS-104.