How do I find the maximum value in a string? surpass
I have several cells that are formatted as text that need to be parsed individually. Each cell contains 14 digits (i.e. 14684968487347) and I need to determine the maximum digit per cell. I figured I could just adjust the left / right formula to break it down, but I figured I'd try to find a way to reduce the file size.
source to share