subfield() help

[pawwy1415]

Hi

Can any one please help me to derive ID column from the Name column

Name                                      

1C Accounting - Payroll Kazakhstan [244346]

2Premier Risk Profile Questionnaire Global UK [2522280]

ID

244346

2522280

Thanks in advance

[StarinieriG · Accepted solution]

Hi,

you could use TextBetween(Name,'[',']')