Apr 26 2021 09:34 AM
I currently have tally marks (uppercase I's) in an excel sheet and I am trying to convert it into values/numbers. Is there a quick way (with highlight) to change all the tally marks into numbers? Thank you.
Apr 26 2021 09:36 AM
Do you have one tally mark per cell, or multiple tally marks in one cell, or a combination?
Apr 26 2021 09:38 AM
Apr 26 2021 09:39 AM
Let's say you have tally marks in cell C2.
The formula =LEN(C2) returns the number of tally marks.
This can be filled down if required.
Does that help?
Apr 26 2021 09:46 AM
Apr 26 2021 10:12 AM
SolutionIf you want to replace the tally marks with numbers, you have two options
1. Using formulas
2. Using VBA.
It would be possible to write a macro that replaces the tally marks with their count in the same cells.
If you want to keep the tally marks, just use the LEN formulas in another range.