Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Culling, Or Selecting, Part Of A Number In A Cell
Hello:
I have a column of numbers, the numbers being 10 digits wide in each cell. I would like to "cut", or cull, 4 digits from part of each number, and save them to a different column. (In other words, to divide the column into two columns with part of the number(s) in each) I seem to remember that there was a vertical line that you could call up to place between two digits in a cell that would separate the cell at that point into two columns. One of the Format commands, I think, but can't seem to find it anymore. Any suggestions on how to do this ? Thanks, Bob |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Culling, Or Selecting, Part Of A Number In A Cell
Try Data/Text to Columns...
In article , "Robert11" wrote: Hello: I have a column of numbers, the numbers being 10 digits wide in each cell. I would like to "cut", or cull, 4 digits from part of each number, and save them to a different column. (In other words, to divide the column into two columns with part of the number(s) in each) I seem to remember that there was a vertical line that you could call up to place between two digits in a cell that would separate the cell at that point into two columns. One of the Format commands, I think, but can't seem to find it anymore. Any suggestions on how to do this ? Thanks, Bob |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Culling, Or Selecting, Part Of A Number In A Cell
You could also do this with a formula, e.g.
=LEFT(a1,4) for the leftmost 4 digits or =MID(a1,4,4) gives you the middle 4 digits etc. "Robert11" wrote: Hello: I have a column of numbers, the numbers being 10 digits wide in each cell. I would like to "cut", or cull, 4 digits from part of each number, and save them to a different column. (In other words, to divide the column into two columns with part of the number(s) in each) I seem to remember that there was a vertical line that you could call up to place between two digits in a cell that would separate the cell at that point into two columns. One of the Format commands, I think, but can't seem to find it anymore. Any suggestions on how to do this ? Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
I need help with an "If" Statement | Excel Worksheet Functions | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |