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


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


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).


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!

How to Cope Up with Your Emotions

Problems and trials in life are everywhere. Some may have lighter problems than the others but yes, ALL of us are battling with different problems.

Sometimes, we experience problems that seems unbearable that we become too depressed and hopeless. Some are brave enough to fight until the end, and sadly, some give up and commit suicide. I admit that there are a lot of times that I feel to do the latter. It’s REALLY HARD. And as the cliché goes, “No one understands you unless they are in the situation.” TRUE! It may seem so easy to give advice and stuffs but once they are in, it’s the time they feel and realize how hard to manage it.

But what if you are like me? I am the type of person who doesn’t easily tell everyone how I feel or what I’ve been going through. It’s always me and me alone. I feel more secured and comfortable with that. And when all the problems and anger have been filled up, I BURST. That’s the negative part of it. But I still choose to handle it alone.

We all struggle to keep cool and smile in all sorts of situations that are happening to us. And how do we cope up with our crazy emotions when we experience overwhelming problems? I may not be an expert but let me share with you some tips on how can we AT LEAST TRY to deal with our emotions.

SUICIDE will never be an option or a solution. Above all, NEVER forget to PRAY and ask for HIS guidance so that you may surpass all the trials that you encounter.