I think I got something here. Not the cleanest solution, but not too bad either. Just takes a little math.
- Here you can see that column 11 has two rows with text in it.
- New Column L has a template with the value of 1 in it.
- New Column J is a template that replaces every letter (and space if you choose) with the number ‘1’. You shouldn’t need to replace any numbers as they are already numbers, but you will probably have to include every letter of the alphabet along with any symbols you would expect to typed in. This makes for a very large set of replacements in a template column.
- Finally, the last column is a math column that determines the number of digits in a number using this formula:
floor(log(n, 10)+1)
Here is the template column to hold a single digit number, such as ‘1’.
Here is the template column that replaces all characters with a number. I only put in a handful of replacements. You can choose to include spaces or not.
Here is the math column that determines the number of digits in that number.
