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
JE McGimpsey - 26 Nov 2006 13:36 GMT
Try Data/Text to Columns...
> Hello:
>
[quoted text clipped - 17 lines]
> Thanks,
> Bob
daddylonglegs - 26 Nov 2006 18:39 GMT
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.
> Hello:
>
[quoted text clipped - 17 lines]
> Thanks,
> Bob