--- title: Larilyn's Tip of the Week:  Microsoft Excel - Last Name First, First Name Last description: Excel Tip image: https://www.inmotionnet.com/hubfs/Add%20column.png --- [Skip to content](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last#main-content) [Contact us](https://www.inmotionnet.com/contact) ![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png) - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) Open main navigation Close main navigation - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Contact us](https://www.inmotionnet.com/contact) Feb 3, 2022 4:30:00 AM # Larilyn's Tip of the Week:  Microsoft Excel - Last Name First, First Name Last [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last) [envelope icon](mailto:?body=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last) Guys.  I have a confession to make.  I mean, you all already know that I'm a nerd.  I've made it pretty clear.  I can't help it.  It's who I am. ![1_plxB_BB3Ju3iOC3KF4aLpQ](https://www.inmotionnet.com/hs-fs/hubfs/1_plxB_BB3Ju3iOC3KF4aLpQ.jpeg?width=509&name=1_plxB_BB3Ju3iOC3KF4aLpQ.jpeg) During the time that was COVID, I binge watched The Mandolorian with my husband.  And can I just say.....I am OBSESSED with Baby Yoda (yes, I know he has a name.  I don't care). ![yoda](https://www.inmotionnet.com/hubfs/yoda.jfif) I mean......he's just the cutest.  And while I know he isn't actually a young Yoda....well.  I don't know what to say here, because really that's not relevant to this conversation.  I'm just trying to segue to the actual Yoda.  Not quite as cute, though still has his charm.  I suppose.  For an old guy. ![Yoda](https://www.inmotionnet.com/hs-fs/hubfs/Yoda.jpg?width=425&name=Yoda.jpg) Anyone who has ever watched Star Wars will know that Yoda has a unique way of talking.  The words don't come out in quite the right order. ![“If-no-mistake-you-have-made-losing-you-are.-A-different-game-you-should-play.”](https://www.inmotionnet.com/hs-fs/hubfs/%E2%80%9CIf-no-mistake-you-have-made-losing-you-are.-A-different-game-you-should-play.%E2%80%9D.jpg?width=410&name=%E2%80%9CIf-no-mistake-you-have-made-losing-you-are.-A-different-game-you-should-play.%E2%80%9D.jpg) Sometimes when I need information from a report and I export it to Excel, it's also not in the right order.  For example, a lot of the times the name will be Last Name First, First Name Last.  However, I want to list people by first name.  I have two options.  Option one is to go line by line, retyping or cutting and pasting to be in the right order.  Not a big deal if it's a list of ten names.  Kind of a big deal if it's a list of hundreds of names. The second option is definitely the better option.  There's actually a way to do this quite simply in Excel.  You start with your names in the column as they are exported. ![Last name first](https://www.inmotionnet.com/hs-fs/hubfs/Last%20name%20first.png?width=361&name=Last%20name%20first.png) Now in most reports you probably have other columns to the right.  You can delete them, or just insert a new column.  We want to work with a blank column B.  In the first cell at the top of column B, you'll type FirstLast, as shown below. ![Add column](https://www.inmotionnet.com/hs-fs/hubfs/Add%20column.png?width=328&name=Add%20column.png) Next, you will type out the very first name the way you want it to actually show - so in this example, you will type out Luke Skywalker. ![one name typed](https://www.inmotionnet.com/hs-fs/hubfs/one%20name%20typed.png?width=397&name=one%20name%20typed.png) Then in the cell to the right of the second name, you just start to type in the name.  I simply typed Dar, and you can see that it filled in the rest of the cell and then filled in the remaining cells in gray. ![second name typed](https://www.inmotionnet.com/hs-fs/hubfs/second%20name%20typed.png?width=511&name=second%20name%20typed.png) It looks like everything filled in correctly, so I simply hit "Enter" without even having to type the rest of Darth Vader, and voila! ![pressed enter](https://www.inmotionnet.com/hs-fs/hubfs/pressed%20enter.png?width=406&name=pressed%20enter.png) The whole list as I want it!  Again, not a huge deal for this short list, but believe me.....when I'm dealing with 900 names or more, this is quite the life saver!   ![Featured-Lifesavers](https://www.inmotionnet.com/hs-fs/hubfs/Featured-Lifesavers.jpg?width=535&name=Featured-Lifesavers.jpg)   [Excel](https://www.inmotionnet.com/blog/tag/excel) ## Related posts [Microsoft Teams](https://www.inmotionnet.com/blog/tag/microsoft-teams) ## [Larilyn’s Tip of the Week: Microsoft Teams – Navigation](https://www.inmotionnet.com/blog/2021/04/larilyns-tip-of-the-week-microsoft-teams-navigation) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Apr 14, 2021 9:00:00 PM I currently feel like a much bigger deal than I actually am. It’s Vlogger Syndrome. Trust me. [Read more](https://www.inmotionnet.com/blog/2021/04/larilyns-tip-of-the-week-microsoft-teams-navigation) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized), [Excel](https://www.inmotionnet.com/blog/tag/excel) ## [Larilyn’s Tip of the Week: Microsoft Excel – Filling Multiple Numeric Cells](https://www.inmotionnet.com/blog/2021/10/larilyns-tip-of-the-week-microsoft-excel-filling-multiple-numeric-cells) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Oct 28, 2021 9:30:00 AM I said I’d be back with another Microsoft Excel tip, and I bet some of you thought I wouldn’t... [Read more](https://www.inmotionnet.com/blog/2021/10/larilyns-tip-of-the-week-microsoft-excel-filling-multiple-numeric-cells) [![](https://www.inmotionnet.com/hs-fs/hubfs/pexels-edmond-dantes-4344878.jpg?height=200&name=pexels-edmond-dantes-4344878.jpg)](https://www.inmotionnet.com/blog/from-offer-letter-to-first-login-how-it-makes-new-hire-setup-easy) [SmallBusiness](https://www.inmotionnet.com/blog/tag/smallbusiness), [productivity](https://www.inmotionnet.com/blog/tag/productivity), [EmployeeOnboarding](https://www.inmotionnet.com/blog/tag/employeeonboarding), [OnboardingProcess](https://www.inmotionnet.com/blog/tag/onboardingprocess), [ITOnboarding](https://www.inmotionnet.com/blog/tag/itonboarding), [NewHire](https://www.inmotionnet.com/blog/tag/newhire), [SmallBizHR](https://www.inmotionnet.com/blog/tag/smallbizhr), [ITSolutions](https://www.inmotionnet.com/blog/tag/itsolutions), [TeamIntegration](https://www.inmotionnet.com/blog/tag/teamintegration), [HRTech](https://www.inmotionnet.com/blog/tag/hrtech) ## [From Offer Letter to First Login: How IT Makes New Hire Setup Easy](https://www.inmotionnet.com/blog/from-offer-letter-to-first-login-how-it-makes-new-hire-setup-easy) [Tricia Tolbert](https://www.inmotionnet.com/blog/author/tricia-tolbert) Aug 21, 2025 4:30:00 AM There’s nothing worse than walking into a new job and spending your first day filling out forms,... [Read more](https://www.inmotionnet.com/blog/from-offer-letter-to-first-login-how-it-makes-new-hire-setup-easy) [![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png)](https://inmotionnet.com) 24930 Washington Ave Unit #157 Murrieta, CA  92564 (951) 894-8809 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. - [Home](https://www.inmotionnet.com) - [Blog](https://www.inmotionnet.com/blog) - [Contact](https://www.inmotionnet.com/contact) - Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Privacy](https://www.inmotionnet.com/privacy-policy) - [Terms](https://www.inmotionnet.com/terms-of-service) --- [linkedin-in icon](https://www.linkedin.com/company/in-motion-networks-corporation/) [Twitter icon](https://twitter.com/InMotionNet/) [facebook-f icon](https://www.facebook.com/inmotionnet/) Copyright © 2026, In Motion Networks Corporation ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Larilyn Holt", "url" : "https://www.inmotionnet.com/blog/author/larilyn-holt" }, "dateModified" : "2022-02-03T12:30:00.642Z", "datePublished" : "2022-02-03T12:30:00.000Z", "headline" : "Larilyn's Tip of the Week:  Microsoft Excel - Last Name First, First Name Last", "image" : [ "https://www.inmotionnet.com/hubfs/Add%20column.png" ], "mainEntityOfPage" : { "@id" : "https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-last-name-first-first-name-last", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.inmotionnet.com/hubfs/InMotionLogoNEW_RGB%20copy.png" }, "name" : "In Motion Networks" } } ```