SUMPRODUCT LEN TRIM range -LEN SUBSTITUTE range 1 Or. Select a range you want to add text to and then click Kutools Text Add Text. Add to formula with Kutools for Excel.
Select a range you want to add text to and then click Kutools Text Add Text.
Make sure you close out the text with. As you see the IF function has 3 arguments but only the first one is obligatory the other two are optional. The next thing we need to do is add the text s Total Duration is enter one more symbol and enter this text in double-quotes. Please do as follows to add one or some characters before each word in a cell in Excel.