Hi,
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)