This function is used when you want to add a particular line or something important before the date, like “last updated”. 

So, to do the same, let’s take an example to understand the whole process:

Previously: How to Count cells equal to either X or Y With COUNTIF?

Last Updated

As you can see in the image above, we have taken a few dates and we will be adding “Last update: “ before the date through a simple way. 

This whole thing is done because when you are dealing with thousands of data, you cannot edit each and every cell one by one.

Last Updated

As we all know that every formula begins with an equal to” sign, so the first thing to do is input the equal to” sign.

Last Updated

Then we will write Last update: or whatever we want to write in the quotation marks.

Please note that if you need a gap between your text and date then you have to show the space in the quotation marks only. Example:

=”Last update:” will come out as Last update:23-04-2017

But =”Last update :” will come out as Last update : 23-04-2017

Giving some space does makes the difference!

Last Updated

Then we will put the and sign i.e. &.

Last Updated

Then comes the TEXT formula.

The TEXT Formula requires value, and format of the text the way we want.

Last Updated

Our value is the date we have in our data.

Last Updated

And our format text, i.e. the format we want to follow to our text is ddd (day), mmmm (month), d (date), yyyy (year). 

Kindly note, you have to put the format in the quotation mark.

Last Updated

So, overall the formula becomes:

=”Last update: “ & TEXT(B3,”ddd, mmmm d, yyyy”)

Last Updated

Now all we have to do is press “enter”.

And BAMMMMM, here comes the answer. Just like you wanted.

Last Updated

Now all you have to do is go to the bottom right corner of the result cell and drag it down so that you don’t have to input the formula again and again for every data entry.

If you want to change “Last update” to anything else, all you have to is edit the same in the formula, the rest of the procedure remains the same.

Last Updated

It’s easy, isn’t it?

Learn : How to split the texts and numbers Using Flash Fill in Excel?