Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting cell
Can anyone tell me how to split a 7 or 8 digit number in a cell so that each
individual digit is in a separate cell on the same row (with margin to right i.e. the right hand most #'s should line up). Thanks anand |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting cell
if A1 contains 12345678
then in B1 thru I1, enter: =MID($A$1,COLUMN()-1,1) -- Gary''s Student - gsnu200726 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting cell
If your data value is in A1, then try this in columns B to I:
=IF(COLUMN()+LEN($A1)<10,"",--MID($A1,COLUMN()+LEN($A1)-9,1)) -- David Biddulph "anand" wrote in message ... Can anyone tell me how to split a 7 or 8 digit number in a cell so that each individual digit is in a separate cell on the same row (with margin to right i.e. the right hand most #'s should line up). Thanks anand |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting a cell | Excel Discussion (Misc queries) | |||
Splitting a cell into two... | Excel Discussion (Misc queries) | |||
Splitting a cell | Excel Worksheet Functions | |||
Splitting a cell | Excel Worksheet Functions | |||
Splitting a Cell | Excel Worksheet Functions |