I have a alphanumeric data in a cell. The combination of these are not a sequence one. For ex: Cell A1 = Adhdhdhd33838
A2 = 9494AdkdkdkA
A3 = /skkfk448dkdk
What is the procedure to split the characters and numeric data seperately and store in a seperate cell. Provide the sample code and formula in case any to be used.
A2 = 9494AdkdkdkA
A3 = /skkfk448dkdk
What is the procedure to split the characters and numeric data seperately and store in a seperate cell. Provide the sample code and formula in case any to be used.