help with excel number string

G

Guest

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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reffering another cell value which contains RAND() 0
Excel 2003 - A string of #s needs to be separated into individual 3
Split text string using mid-search? 3
How to split number and text string to separate cells? 5
How to count the number of occurrence within string? 2
Splitting Numbers into Columns. 3
Scan from a document to excel with separate cells 1
Keeping a cell or value constant in further equations 1

Top