Let's now investigate the ranges of electric vehicles in the US$.$ The range of an electric vehicle is the theoretical number of miles it can travel without needing to be recharged.

Hint: Use the FIND$(),$ LEN$(),$ RIGHT$(),$ LEFT$(),$ TRIM$(),$ and VALUE$()$ functions to wrangle the data. It is also useful to start with Text to Columns, available under the Data tab, and split by $-.$ Notice that all years have four characters and all ranges have three. You must recreate all four columns for credit, but as long as you can extract the year and mileage you will be able to complete exercises $6$ and $7.$