software

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

=MID($A$1;COLUMN(A1);1)

Copy to the right

--
Kind regards,

Niek Otten

quot;caloyquot; gt; wrote in message
...
gt;I have a string of numbers, 25 characters long which is in a cell. Iam
gt; looking to find a function/solution so that I can place each individual
gt; value
gt; within the string into individual cells.
gt;
gt; Ex.
gt; 131112213111231111223311 - this string is in cell A1
gt; I want to distribute each number into individual cells (ex. B1 through
gt; AA1)
gt; --
gt; Caloyski
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!)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;caloyquot; gt; wrote in message
...
gt;I have a string of numbers, 25 characters long which is in a cell. Iam
gt; looking to find a function/solution so that I can place each individual
gt; value
gt; within the string into individual cells.
gt;
gt; Ex.
gt; 131112213111231111223311 - this string is in cell A1
gt; I want to distribute each number into individual cells (ex. B1 through
gt; AA1)
gt; --
gt; Caloyski
Nick,
Thanks for the assistance!
--
Caloyskiquot;Niek Ottenquot; wrote:

gt; =MID($A$1;COLUMN(A1);1)
gt;
gt; Copy to the right
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;caloyquot; gt; wrote in message
gt; ...
gt; gt;I have a string of numbers, 25 characters long which is in a cell. Iam
gt; gt; looking to find a function/solution so that I can place each individual
gt; gt; value
gt; gt; within the string into individual cells.
gt; gt;
gt; gt; Ex.
gt; gt; 131112213111231111223311 - this string is in cell A1
gt; gt; I want to distribute each number into individual cells (ex. B1 through
gt; gt; AA1)
gt; gt; --
gt; gt; Caloyski
gt;
gt;
gt;