I am downloading data that is currently in the form of arrange(e.g. 55-60). I would like to ask Excel to take that range and find the middle point and replace the range with the middle point value. There is a large amount of data that I want to convert this way. Right now my cells look like this: 0.50 - 0.55
I want it to look like this: 0.525
Does anyone know any easy way to do this?
Best, Maddy
Bookmarks