The problem : Format Names from FName LName to LName, FName, How to Format Your Excel xname lname, fname lname Spreadsheets (Complete Guide).
Do you work a lot of the Filter data in Excel. Do have to all the data manipulate a lot of format datatype of the text related strings or some values. This tricks and tips might create life a tiny but very easier. This will help you step by step convert a all the list of values from
Convert from XNAME LNAME – FNAME LNAME to LNAME FNAME
<FirstName LastName> to <LastName, FirstName>
- Step 1: Format Names with xname lnames fname
- Step 2: Formula in cell B2:
- Step 3: Format Names from FName LName to LName, FName
The Question: A simple long list of names are obtainable as FName LName (First Name / Last Name).
So, you require to show bellow as User Last Name(lnames), First Name(FName) or fname lnames.
Step 1: Format Names with xname lname fname
Do note that the names may not always be Two words, they may data contain 3,4 or more all the words. (Eg: Narendra Damodardas Modi). The assumption here is the Last word (Modi, in bellow case) is always the xnames lname Last Name (or Surname).
Step 2: Formula in cell B2:
=RIGHT(SUBSTITUTE(TRIM(A2),” “,”~”,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2),” “,””))),LEN(SUBSTITUTE(TRIM(A2),” “,”~”,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2),” “,””))))-FIND(“~”,SUBSTITUTE(TRIM(A2),” “,”~”,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2),” “,””)))))&”, “&LEFT(SUBSTITUTE(TRIM(A2),” “,”~”,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2),” “,””))),FIND(“~”,SUBSTITUTE(TRIM(A2),” “,”~”,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2),” “,””))))-1)
Step 3: results of Format Names from FName LName to LName, FName
simple you can here your column Drag and drop the formula till excel sheet the bottom of the display list as well as you have a simple way to again recheck reformat your all the list of user names.
Good Luck! Works on your all the Names with Two words or even multiple like more than Two.
Web Programming Tutorials Example with Demo
Read :
Summary
You can also read about AngularJS, ASP.NET, VueJs, PHP.
I hope you get an idea about Xname Pa * Day Weather Forecast – Weather Today.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.
