Follow the steps below to convert fractions to percentages in Google Sheets using the REGEXEXTRACT function. This method treats fractions entered as text, which can be especially useful if Google Sheets isn't interpreting your fractions as expected.
First, input the fractions into column A of your Google Sheets document starting from cell A1. Type them exactly as shown below, treating them as text entries:
Make sure to directly type the fractions into the cells without any formatting.
In cell B1, input the formula to convert the text fraction in A1 into a decimal. Use the following formula:
=ArrayFormula(if(len(A1:A), regexextract(A1:A, "^\d+") / regexextract(A1:A, "\d+$"), ""))
This formula will work down column A, converting any fraction it finds into a decimal equivalent. It checks if the cell is not empty (if(len(A1:A)), extracts the numerator (regexextract(A1:A, "^\d+")), extracts the denominator (regexextract(A1:A, "\d+$")), and performs the division.
The formula will give you decimal results in column B. To convert these decimals to percentages, you need to format column B as a percentage.
Select column B by clicking on the "B" at the top of the column. Go to the "Format" menu, choose "Number," then select "Percent."
Now, the decimal values in column B will be formatted as percentages.
You might notice that the percentages are rounded to the nearest whole number or have too many decimal places. To adjust this: With column B still selected, use the "Increase decimal places" or "Decrease decimal places" buttons in the toolbar to achieve the desired precision.
We hope that you now have a better understanding of how to convert fraction to percent in Google Sheets. If you enjoyed this article, you might also like our article on how to sort by month in Google Sheets or our article on how to insert euro symbol in Google Sheets.
