Prev: Search end/beginning of cell
Next: SUMPRODUCT(ARRAY) RETURNING "VALUE#"
From: Daphtg on 28 Apr 2010 17:34
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.
From: Gord Dibben on 28 Apr 2010 17:43
See reply at your earlier post.


Gord Dibben MS Excel MVP

On Wed, 28 Apr 2010 14:34:08 -0700, Daphtg
<Daphtg(a)discussions.microsoft.com> wrote:

>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.

 | 
Pages: 1
Prev: Search end/beginning of cell
Next: SUMPRODUCT(ARRAY) RETURNING "VALUE#"