Skip to content

Allen Lew's Thoughts

My answer to "life, the universe and everything"

Posted on February 7, 2008November 17, 2012 by Allen Lew

Split First and Last Name into Seperate Columns in Excel.

If you have a First Name and Last Name in one column in Excel, here’s a tutorial on splitting them into two separate columns (without VB macros) from LauraJ’s blog. It involves using the Data to Text feature. Very handy.

CategoriesAsides, Software, Tips TagsMicrosoft Excel

Post navigation

Previous PostPrevious How many countries can you name in five minutes?
Next PostNext Los Angeles Urban League Domestic Violence PSAs

About Allen

Allen Lew is a technologist who likes to write about all sorts of things. More about Allen

Pages

  • About Allen Lew
  • About the Site
  • Contact Me

Recent Posts

  • 2 Months of The FI Guys
  • Launch: Planet FI, from The FI Guys
  • Launch: The FI Guys website
  • My American English to British English Spreadsheet
  • 2018 New Years Resolution: Achieve the Pillars of Financial Independence

Archives

Categories

  • Asides
  • Books
  • Business
  • Conferences
  • Design
  • Featured
  • Finance
  • Food
  • General
  • Humor
  • Jobs
  • Movies
  • Music
  • Non-Profit
  • Opinion
  • Photos
  • Politics
  • Quotes
  • Reviews
  • Science
  • Scripts
  • Software
  • Sports
  • Startups
  • Stuff I Use
  • Superheroes
  • Technology
  • The Internet
  • Tips
  • Toys
  • Travel
  • TV
  • Video Games
  • Videos

Tags

  • 30 Days of Wisdom
  • ads
  • Advertising
  • Al Gore
  • Arrested Development
  • Batman
  • Blogging
  • celebrities
  • Civil War
  • Climate Change
  • Countries
  • Creative Commons
  • Dating Abuse
  • Domestic Violence
  • Drupal
  • Elijah Wood
  • Environment
  • Facebook
  • Family Guy
  • financial independence
  • Firefox
  • Games
  • Global Warming
  • Google
  • Los Angeles Urban League
  • Mac
  • Macworld
  • Movable Type
  • Napa
  • Napa Valley
  • nintendo
  • nptech
  • OpenID
  • Palm Apps
  • Relay for Life
  • school
  • Sergey Brin
  • Social Networking
  • summer 2006
  • Tweets
  • Twitter
  • Voicemail
  • Wikipedia
  • Wordcamp
  • Wordpress
Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Proudly powered by WordPress