Other Text Functions: T(), REPT ()

Unlock powerful text manipulation with functions like T() for handling text values and REPT() for repeating text in your formulas.

In this article, we will learn

  • T()

  • REPT()

These functions are very simple, so it won’t take too long to learn how they work.

  1. T(): Return the argument if it is test otherwise blank

    Result:-

  2. REPT():  It repeats a string for the given number of times.

    Syntax: REPT(“String”, No of times)

    Result: 


Did this answer your question?
😞
😐
😁