Splitting multiple cell contents from 1st column into 4 columns

D

Daphtg

n my first column I have 4 cells (1-4) (5-8) etc. with general content.
The content from each of these 4 cells needs to be placed in a separate
column to make a list that I can sort etc.
Example: COLUMN A
1 01-04-425-001
2 Heatherridge Road #301
3 Harry Smith
4 H25 Condo Fairfax Place
5 01-05-356-041
6 McGrath Street # 56
7 Mary Jones
8 B45 Condo Lemon Circle . . . . . . and so on and so on
every 4 cells.
I have hundreds of 4 cell descriptions. I just can't do this one by one.
Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I
use it for everything everyday.
There must be some kind of a formula or something.

Thank you so much in advance. I can't spend the next 6 months doing this one
by one or retyping each one. I have many other things to do in my job.

By the way I am on a MAC 10.4.11 using Excel 2004 if that makes a difference.
 
D

Daphtg

I am sorry but I don't have an earlier post. I posted yesterday in both
General Questions and Worksheet Functions and have received no replies except
this one.

Thank you.
 
G

Gord Dibben

You do have another post in excel.worksheet.functions and here is my reply
to that post.

In B1 enter this formula

=INDEX($A$1:$A$4000,4*ROWS($1:1)-4+COLUMNS($A:A))

Drag/copy across to E1

Select B1:E1 and drag/copy down until you get zeros.

Alter the 4000 if you need more rows.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top