Forum Discussion
Convert Text to specific numbers
I have the data below: This is an attendance record. The data in the cells need to be converted into certain numbers as shown below: ...
As a comment, if conversion is needed to do some stats (sum, average, etc attendance), I'd do that within such stats calculations. Report with letters looks more human friendly.