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

Script:

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

Result: 3

The function split is used to split the string into a sequence; the option @n means splitting by CR (you don’t have to use this option, you can use the parameter "\n” 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
15.1 Split string - separate by comma – automatic parsing of data type
15.3 Split string - separate by multi-character separator