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.

+3


source to share


1 answer


One way to imagine a lot:



=MATCH(100,FIND({0,1,2,3,4,5,6,7,8,9},A1))-1

      

+6


source







All Articles