#Tip of the Day: How to Separate First Name and Last Name in Microsoft Excel

It’s TIP OF THE DAY Tuesday!

Whether you’re working at the office or at home, this will be very helpful to you especially if you’re dealing with contact list or database. Of course, we don’t want to MANUALLY sort the names and consume a lot of time with one task that you can do in a snap, right?

So today, as obviously mentioned in the title of this post, I’ll be sharing with you some tips/tricks on how you can do name separation in Microsoft Excel effortlessly. There are two ways that we can do this. First is name by USING FORMULAS and second is by USING FLASH FILL.

Let us start with the first trick: FORMULAS.

1. Prepare your table with list of full name. Add two more columns for first name and last name.

2. Start to separate the first name using this formula:

Example:

3. Proceed on the last name using the below formula:

Example:

4. Click on the cell of first name/last name and drag the small dot (found on the lower right corner of the cell) downwards. You may also double click that small dot to copy the formula in the entire column.

Easy, right? Now let’s make it EASIER than that. ^_^

This next trick is the FLASH FILL. This is like “following the leader” technique. It follows the pattern that you set on your first row of name separation. Let’s proceed!

1. Prepare your table with list of full name. Add two more columns for first name and last name.

2. Type the pattern for first name and last name on the first row (first full name).

Example:

Type Joyce, as the first name, on B2 cell.

Type Lee, as the last name, on the C2 cell.

3. Click the first pattern. In the above sample, B2 cell.

4. Hold CTRL + E on your keyboard. The list will automatically be filled up following the pattern.

5. Do the same thing for the last name. From the above sample, click on C2 cell. Then repeat #4.

That’s it! Cool, right? ^_^

Feel free to try them and let me know how it goes. Enjoy!

TOP 12 MS Excel Shortcuts that You Should Know

It’s sad to accept the fact that during our school years, we did not learn much about MS Excel, well in fact it is the MOST used application/software (or whatever it should be properly called) when we enter the corporate world or simply when we start working. Honestly, I just learned the actual Excel when I started working in the office. Most of the things I learned about Excel are self-study, some are from our office trainings and some are from YouTube.

 

There’s a TON of MS Excel shortcuts but let me share with you some beneficial keyboard shortcuts that you should know. Open your MS Excel application and feel free to try the below shortcuts as we go along.

 

(Disclosure: These are random shortcuts depending on which I remembered first. ^_^)

 

1

 

2

 

3

 

4

 

How was it? Hope these will be useful to you as these are to me. 🙂

 

Do you want to know more tips and tricks on Excel? Let me know which field or topic, or if you have questions that I may be able to answer. Comment down below.

 

fwt-signature.png