For example inserting the TODAY function in the Text formula with the format code dddd d mmm yyyy will return a string similar to this.

Text formula in excel with example. The TEXT function is useful when concatenating a formatted number to a text string. Lets take an example. When given the reference of a cell that contains a formula it will return the entire formula as text.

IF B1excelyesno IFB1EXCElyesno The IF formula will check the values of cell B1 if it is equal to excel word If it is TRUE then return yes otherwise return no. This time we simply use the TEXT function without adding text. Without the TEXT function the number formatting will be stripped.

Formula TextValue format_text Where. TEXT 1234567 000 Currency with a thousands separator and 2 decimals like 123457. When a numeric value in excel exceeds value 99999999999 then excel always represents that value in scientific notation.

Excel Text function can also be used for the numbers with large values for example telephone numbers. To replace existing text with new text in a string use the SUBSTITUTE function. Visit our page about the FIND function for more examples.

The TEXT Function works exactly the same in Google Sheets as in Excel. The below function and screenshot shows this Excel Text formula. Learn more about text functions Next Chapter.

Today is Thursday 18 Oct 2019. For example if you want to pull the date from cell A2 and show it in another cell in the traditional date format like January 1 2016 you use the following Excel TEXT formula. Here is the syntax for TEXT function.