REP-function

If you want to write the same character for more times in a cell, you use REPT() function. You firstly write the character in " ", after you write the number of times it repeats.

 If you want to write the repetition of two different characters with different  arrangement, you use two nested REPT() function.

In third example, first REPT() function inside represent to write "#" character for 5 times; the second REPT() represents after 5 times # character 1 time "  " (double space) character. You can see it in result.

Related Trainings

Badly Formatted Data

Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.


International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.


Travel Budget

Travel Budget

Create a "Travel Budged" sample.