Hi I want to seperate Name&ID and have to stored ID no in ID Column excel If string Nikita2233 it split to Nikita and 2233 How can I do it? Thanks in advance. I’m attaching Screenshot Also [image] Excel File Test.xlsx (9.4 KB) Output Should be(ID Number) stored in ID column

Split string by number and stored number in Excel ID Column

Rahul_Unnikrishnan (Rahul Unnikrishnan) June 14, 2022, 6:34am 2

You can check the below post.

1 Like