Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with excel number string
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with excel number string
=MID($A$1;COLUMN(A1);1)
Copy to the right -- Kind regards, Niek Otten "caloy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with excel number string
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.laanemets<attarkon.ee ) "caloy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with excel number string
Nick,
Thanks for the assistance! -- Caloyski "Niek Otten" wrote: =MID($A$1;COLUMN(A1);1) Copy to the right -- Kind regards, Niek Otten "caloy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Change number when you open the excel template | Excel Discussion (Misc queries) | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Excel not taking number format consistently | Excel Discussion (Misc queries) | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel |