Hello,

If I understand the problem correctly Max was almost the
=IF(A1="","",IF(ISNUMBER(A1),A1,--LEFT(A1)+CODE(LEFT(A1))/10^10))

If there can be more than one letter suffix I suggest to use
RegExpReplace to separate numerical and text parts...

Regards,
Bernd