G
Guest
How do I move a list of 15000 numbers from one column to 6 or 8 to make it
easier to display.
easier to display.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
cut and paste?
M
mphell0
What do your numbers look like now and how do you want them to look?
G
Guest
15000 numbers, I was looking for an automated process
G
Guest
15000 telephone numbers. I want them to be in 6 or 8 columns, instead of 1
M
mphell0
You're going to have to give more details. Can you give an example o
what
you are trying to do? What part of the number would go into anothe
column
what
you are trying to do? What part of the number would go into anothe
column
M
mphell0
If you have a number like 1-123-456-7890 and you want it to be
1 in a column
123 in another
456 in another
7890 in another
You can use Data->Text to columns selected delimited and fo
delimiters
select other and enter "-
1 in a column
123 in another
456 in another
7890 in another
You can use Data->Text to columns selected delimited and fo
delimiters
select other and enter "-
G
Guest
I have imported a file of telephone numbers. There are 15,000 numbers in a
single column. If I printed or displayed the numbers, I would only see 60
(or so)per page. I would like to move spread those 15,000 telephone numbers
in multiples columns. So when I run a report, I have numbers in 6 or 8
columns rather than one. Purely for printing and display.
single column. If I printed or displayed the numbers, I would only see 60
(or so)per page. I would like to move spread those 15,000 telephone numbers
in multiples columns. So when I run a report, I have numbers in 6 or 8
columns rather than one. Purely for printing and display.
V
vezerid
Do the following:
Decide on the number of columns that you want. Let us say you want 6
columns. In the row put the numbers 0...5 (a total of 6 numbers)
Assuming you want your transferred data to start from row 2, below the
0, use the following formula:
=OFFSET($A$2,(ROW()-2)*6+D$1,0)
In this formula, we assume your phone numbers start from A2, that you
have 6 columns and that the 0...5 start from D1. Copy as far down and
across as necessary.
HTH
Kostis Vezerides
Decide on the number of columns that you want. Let us say you want 6
columns. In the row put the numbers 0...5 (a total of 6 numbers)
Assuming you want your transferred data to start from row 2, below the
0, use the following formula:
=OFFSET($A$2,(ROW()-2)*6+D$1,0)
In this formula, we assume your phone numbers start from A2, that you
have 6 columns and that the 0...5 start from D1. Copy as far down and
across as necessary.
HTH
Kostis Vezerides
G
Guest
You could do something like this. Since 15000/6 = 2500, you could hit Cntl-g
(for goto, type the range a2500:a5000 (or something very similar) hit cntl-x
(for cut,)
then right arrow end up (hopefully you will now be in b1,) and cntl-v for
paste. Repeat the process going from, for instance a5001:a7500 (or
thereabouts.) When finished doing all 6 (or 8) columns, go down to row 2500.
Hold shift and then hit cntl-end to go to the bottom of your spreadsheet,
right click and hit delete and answer entire row. Then save (this should
make it so Excel doesn't think your used range is as far down as it was
originally.)
(for goto, type the range a2500:a5000 (or something very similar) hit cntl-x
(for cut,)
then right arrow end up (hopefully you will now be in b1,) and cntl-v for
paste. Repeat the process going from, for instance a5001:a7500 (or
thereabouts.) When finished doing all 6 (or 8) columns, go down to row 2500.
Hold shift and then hit cntl-end to go to the bottom of your spreadsheet,
right click and hit delete and answer entire row. Then save (this should
make it so Excel doesn't think your used range is as far down as it was
originally.)
G
Guest
Thank you. I will try that.
G
Guest
Thanks. Someone else gave me an automated way. See vezerid
G
Guest
thank you. Someone gave me another. See vezerid I will try them all.