Convert Text to Year in Excel

The easiest way to convert text to a year in Excel is with the TEXT function. It takes a value as the first argument and formatting as the second.

You can use the following formula to convert the date in Cell A2 and display it as a year only.

You can also display the last two digits of the year by using this formula.

You can also use the text formula to display months, days, hours, minutes, and seconds, and separate them with a dash, slash, or any other separator.

You can combine this date with text to make it more readable.

And with the CONCAT function.