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