You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

If your Excel cell or row contains two or more values, you can split that data across multiple cells. For Excel to divide the values, however, the cell must contain a delimiter, a character that ...

To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into percentages. If your data is formatted as an Excel table, hover over the ...