Here is a comma-separated number string. To find the largest number:

Script:

=spl("=?1.split@cp().max()",A1)

Result: 45

The function split is used to split the string into a sequence; the option @c means splitting by comma (you don’t have to use this option, you can use the parameter “,” instead); the option @p means automatically parsing the data type, for example, the integer string can be parsed into integers.

esProc Desktop and Excel Processing
14.11 Generate permutations and combinations
15.2 Split string - separate by carriage return (CR) - automatic parsing of data type