How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating.
I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers?
Thanks for any help.
