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.
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.