How To Use REPT Function In Excel –Funny And Simple Tutorial

Date:2021-7-23 Author:Sandra

We have learned how to use the EXACT function in the last tutorial. Today, we are going to get something new—that’s the REPT function.

The REPT function repeats characters or text a given number of times.

Syntax:

=REPT(text, number_times)

Look at the example below. We type =REPT(“*”, A3) in cell B3 and press Enter key. This function will make the text “*” repeat 5 times in cell B3.

How To Use REPT Function In Excel –Funny And Simple Tutorial

We already know how to use the function from this picture example. So how do you make this function interesting and useful?

Type [=REPT(“★”,ROUNDDOWN(B3,0))&REPT(“☆”,ROUNDUP(10-B3,0))] in cell C3 and press Enter key.

How To Use REPT Function In Excel –Funny And Simple Tutorial
How To Use REPT Function In Excel –Funny And Simple Tutorial

This function can help us complete the star rating quickly. In addition to star ratings, we can also quickly create special bar charts.

How To Use REPT Function In Excel –Funny And Simple Tutorial
How To Use REPT Function In Excel –Funny And Simple Tutorial

Oh, that’s quite funny and useful. Quickly open your Excel sheet to have a try.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *