Home > Blog > How-to-add-date-or-formula-inner-side-of-text-in-excel
How to add date or formula inner side of text in excel
If you're trying to display the month or text from other cell, and that cell contains a full date or text, then you would typically use a text function to extract just the month name or year or text .
Here are a few ways to do it, depending on the software you're using (most commonly Excel or Google Sheets):
="For The Month Of " & TEXT(cell,"mmmm")
TEXT(cell,"mmmm") tells the software to take the date in sell and format it as the full month name.
="For The Month Of " & TEXT(cell,"mmm")
for short month name.
="For The Month Of " & cell
for only text extract.
Which option is best for you?
It depends on what's in cell and how you want the data to appear.
Comments