@Jaspal80 are you able to provide a little more info here - is this a consistent pattern/format and you'll always be splitting the data into 4 columns with these names? If so you can use RegEx in Tokenize mode which will extract x occurrences of a pattern (in this case more than 1 number, 4 times, which looks to be what you want to pull out). We then just use a select to remove the original column and set the names:
If there's variation and perhaps different names etc then we'll need more information and a wider range of examples. Hope this helps to get you started.
I'm not sure how dynamic you need it, but here's a solution using the Text To Columns Tool,
