Split xyz45 into xyz and 45

Help Activities
, ,
1

i have column 1 xyz name and value 45
ex :xyz45 how will i split it in excel

2

Are you looking for this?
grafik

3

suppose
Nameand rollno. Name rollno. i want to split in excel.
xyz45

4

it would be helpfully when you elaborate more precise
just tell us the input value and the expected output (datatype, value)
Thanks