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

%3CLINGO-SUB%20id%3D%22lingo-sub-2256439%22%20slang%3D%22en-US%22%3EClick%20the%20Text2%20box%20and%20nest%20the%20TEXT%20function%20from%20the%20Text%20category.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2256439%22%20slang%3D%22en-US%22%3E%3CP%3EUse%20%3CEM%3ECONCAT%3C%2FEM%3E%20to%20display%20a%20sentence%20about%20the%20current%20date.%3C%2FP%3E%3COL%3E%3CLI%3EClick%20cell%20%3CSTRONG%3EA22%3C%2FSTRONG%3E%20on%20the%20%3CSTRONG%3EAging%20Detail%3C%2FSTRONG%3E%20sheet%20and%20start%20a%20%3CEM%3ECONCAT%3C%2FEM%3E%20formula.%3C%2FLI%3E%3CLI%3EType%20%3CSPAN%20class%3D%22red%22%3E%3CSTRONG%3EToday%20is%3C%2FSTRONG%3E%3C%2FSPAN%3E%20with%20a%20space%20after%20the%20word%20%E2%80%9Cis%E2%80%9D%20for%20the%20%3CEM%3EText1%3C%2FEM%3E%20argument.%3C%2FLI%3E%3CLI%3EClick%20the%20%3CSTRONG%3EText2%3C%2FSTRONG%3E%20box%20and%20nest%20the%20%3CSTRONG%3ETEXT%3C%2FSTRONG%3E%20function%20from%20the%20%3CEM%3EText%3C%2FEM%3E%20category.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EHow%20do%20I%20nest%20the%20%3CSTRONG%3ETEXT%3C%2FSTRONG%3E%20function%20from%20the%20%3CEM%3EText%3C%2FEM%3E%20category%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2256439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

@teeks88 

What is Text2 box?

You may type as

image.png

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