Forum Discussion

teeks88's avatar
teeks88
Copper Contributor
Apr 06, 2021

Click the Text2 box and nest the TEXT function from the Text category.

Use CONCAT to display a sentence about the current date.

  1. Click cell A22 on the Aging Detail sheet and start a CONCAT formula.
  2. Type Today is with a space after the word “is” for the Text1 argument.
  3. Click the Text2 box and nest the TEXT function from the Text category.

How do I nest the TEXT function from the Text category?

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    teeks88 

    What is Text2 box?

    You may type as

    with selecting any function to continue with if you'd like to select it from ribbon menu.

Resources