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:
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.
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.
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!
Then we will put the and sign i.e. &.
Then comes the TEXT formula.
The TEXT Formula requires value, and format of the text the way we want.
Our value is the date we have in our data.
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.
So, overall the formula becomes:
=”Last update: “ & TEXT(B3,”ddd, mmmm d, yyyy”)
Now all we have to do is press “enter”.
And BAMMMMM, here comes the answer. Just like you wanted.
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.
It’s easy, isn’t it?