Introduction to Strings
Lets learn about REPT Function in Excel. Strings are blocks of text that appear in Excel, like names of people, names of cities, e-mail addresses, or names of items sold in a store. When we type strings into Excel, we always use quotation marks around them to tell Excel that what it’s about to read is one coherent block of text.
What are String Functions in Excel ?
In Excel, there are multiple string (text) functions that can help you to deal with textual data. These functions can help you to change a text, change the case, find a string, count the length of the string, etc. In this post, we have covered top text functions.
Download Practice files for Text Functions
Download Excel Text Sample Files to move along with the tutorial and master the skill of using LEN Function in Excel.
What is REPT Function in MS Excel ?
REPT function returns a text value several times. In simple words, with the REPT function, you can specify a text, and a number to repeat that text.
Syntax of REPT Function
REPT(value1, [value2], …)
Example of REPT Function
In the below example, we have used different type of text for repetition using REPT. It can repeat any type of text or numbers and even symbols that you specify in function and the main use of the REPT function is for creating in-cell charts.
