In excell how I can from the information in one cell distribute the
same in 13 diferent cells to be more specific I want to convert this
cell:
07/13/05    04-13-21-33-34-47   aa   bb    cc   dd   ee
 in the following 13 cells
07/13/05
04
13
21
33
34
47
aa
bb
cc
dd
ee

---

Clarification of Question by chocolamu-ga on 16 Jul 2005 10:43 PDT

I have to Discompose more than 500 cells each in 13 cells so it should
be I imagine a logical function  that will say Just take 2 characters
after you observe a "-" or the firs space.  I know how to doit
manually, I just want to save some time!

---

Request for Question Clarification by efn-ga on 16 Jul 2005 15:44 PDT

Do you want the output cells to be columns in the same row or rows in
the same column, or does it matter?

That is, if you start with, say

| a-b c |

should the result be

| a | b | c |

or

| a |
|---|
| b |
|---|
| c |

or is either acceptable?

Would an answer based on Excel 2000 be acceptable?

---

Request for Question Clarification by hummer-ga on 16 Jul 2005 17:30 PDT

Hi chocolamu,

Try this and let us know if you get the desired results.

1) Select the column (or cell) you want to change.
2) Click on the DATA drop-down menu button, then TEXT TO COLUMNS.
3) Select (tick mark) DELIMITED and hit Next.
4) Select (tick mark) TAB and SPACE and OTHER (type " - "in the field), hit Next.
5) Click on the DESTINATION LITTLE BOX (to the right of the field).
6) Select the thirteen columns you want the data to appear in.
7) Click on the DESTINATION LITTLE BOX again and hit Finish

Will look forward to your reply,
hummer

---

Clarification of Question by chocolamu-ga on 16 Jul 2005 19:39 PDT

hummer-ga  You answer my question- Please I am new in this procedure
so you should get the comission. Should I  cancel the QUETION?

Good news, chocolamu! Thanks for letting me know. No, don't cancel the
question, you've done just the right thing and now all is well.

Here is the answer again, to make it official. I'm glad it worked for you.

1) Select the column (or cell) you want to change.
2) Click on the DATA drop-down menu button, then TEXT TO COLUMNS.
3) Select (tick mark) DELIMITED and hit Next.
4) Select (tick mark) TAB and SPACE and OTHER (type " - "in the field), hit Next.
5) Click on the DESTINATION LITTLE BOX (to the right of the field).
6) Select the thirteen columns you want the data to appear in.
7) Click on the DESTINATION LITTLE BOX again and hit Finish

Thanks again, take care,
hummer

Very specific, fast and understandable

try data/text to columns

I dont get what you mean!

I have to Discompose more than 500 cells each in 13 cells so it should
be I imagine a logical function  that will say Just take 2 characters
after you observe a "-" or the firs space.  I know how to doit
manually, I just want to save some time!