You can use the VALUE function to return just the numeric value of the text. 1. Insert a new column Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column. 2. Use the VALUE function In one of Read More