| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking to break a large number down
Sorry, I would search the topics but I am unsure even what to look for.
I have a column of number that are three digits in size. They could range from 001 through 999. I would like to split it up so each digit is in it's own column. So if ColumnK had the number 459 in it then I would like ColumnM to show the number 4, ColumnN to show the number 5 and ColumnO to show the number 9. Same with if the number is 99 (ColumnK would show 099, and I would want the number 0 to show in ColumnM). Thank You Everyone who knows how to do this. :) David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Looking to break a large number down
=left(k1,1)
=mid(k1,2,1) =right(k1,1) "David" wrote: Sorry, I would search the topics but I am unsure even what to look for. I have a column of number that are three digits in size. They could range from 001 through 999. I would like to split it up so each digit is in it's own column. So if ColumnK had the number 459 in it then I would like ColumnM to show the number 4, ColumnN to show the number 5 and ColumnO to show the number 9. Same with if the number is 99 (ColumnK would show 099, and I would want the number 0 to show in ColumnM). Thank You Everyone who knows how to do this. :) David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking to break a large number down | Excel Discussion (Misc queries) | |||
| Looking to break a large number down | Excel Discussion (Misc queries) | |||
| How do I break a large .CSV file into several small Excel files? | Excel Worksheet Functions | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
Linear Mode
