Forum Discussion
Thaddaeus
Nov 23, 2024Copper Contributor
Numeric range conversion
As part of survey data, I have an Excel column that is a numeric range for the time each respondent commutes (in minutes): 1-5, 6-10, 11-15, 16-20, 21-25, etc. up to 85-90, 90+. This was a mistake as...
Harun24HR
Nov 23, 2024Silver Contributor
You may try the following formula-
=AVERAGE(--TEXTSPLIT(A1,"-"))