Modified 12 June 2020 by Eugen Plesa

It's quick and easy to add a star rating system to your Google Sheets, using the REPT and CHAR functions.

Here's a table showing a list of movies and their ratings:

Column B is a numerical value representing the rating.

In column C, you transform that value into a more visually appealing star rating.

The star is created with the CHAR function, which returns a character based on a Unicode number.

 You use the REPT function to repeat the star corresponding to the rating value.

The formula for row 2 is:

=REPT( CHAR( 9733 ) , B2 )

You drag this formula down the column to fill in the other star ratings:

Guest Tip by Ben Collins