Posted in Business, Lifestyle, Technology, Tips & Ideas

#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!

Author:

Sole owner of FlipWebToday.com. A mother of two adorable boys, Aki & Yoshi. A working mom. A digital disciple.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s