How to seperate dynamic text which has text and integers

I have dynamic combined text and integer or vice versa but want to seperate them, please refer to excel sheet.
Input = Material Information.
Output 1 = Material Name
Output 2 = Material Details

How to segregate them, please helpsubstring.xlsx (8.2 KB)

can you give the pattern how to separate text on those examples ?

Hi, as shown in excel want to seperate as Material Name and Material Details

Hi @Sudhir_P

There must be a pattern to identify Material Name and Material Details from Material Information. Please clarify that coz in excel even characters also coming in material details and material name is captured as 990mm…

If you clarify, how Material name and Material details actually separated it would be helpful to split required text from Material Information.