help with excel number string

C

caloy

I have a string of numbers, 25 characters long which is in a cell. Iam
looking to find a function/solution so that I can place each individual value
within the string into individual cells.

Ex.
131112213111231111223311 - this string is in cell A1
I want to distribute each number into individual cells (ex. B1 through AA1)
 
A

Arvi Laanemets

Hu

Use Text To Columns feature - select Fixed Width, and divide the column into
25 single-character columns (NB! you must have 24 free columns to right of
column with data!)
 
Top