I need some help. I'm working on a 4,500 row worksheet. In each cell, there
is a lot of information. For example:

A1 would read: KWI 200DNL 11P DOR PASSAGE

What i need to do is rearrange the 200P so it's after PASSAGE. What I've
been doing so far is setting up a CONCATENATE function and having to type out
each "word" in a new column. (KWI in A2, 11P in A3, etc). These cells are
all different and some have more or less information. Is there a way where i
can automatically drag each word out into a new column next to the original
cell so i can click and drag the concatenate function down to the last cell?
please help!

-pyager

Sorry, I meant 200DNL.

I should look like this:
KWI 11P PASSAGE DOR 200DNL

but i need to do that for 4,500 cells...

You can parse the data using <Data<Text to Columns<Delimited<Space<Finish

Try it, you'll like it.

Tom

YOU'RE RIGHT! I DO LOVE IT! AND I LOVE YOU FOR SHOWING ME THIS. YOU JUST
SAVED ME A BUNCH OF TIME!

THANKS!!

You need to give us more examples so we can see that has to be extracted
Are there always exactly 3 characters and a space in front of 200DNL ?
Is the thing to move always 200DNL ?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"pyager" wrote in message
...
I need some help. I'm working on a 4,500 row worksheet. In each cell,
there
is a lot of information. For example:

A1 would read: KWI 200DNL 11P DOR PASSAGE

What i need to do is rearrange the 200P so it's after PASSAGE. What I've
been doing so far is setting up a CONCATENATE function and having to type
out
each "word" in a new column. (KWI in A2, 11P in A3, etc). These cells
are
all different and some have more or less information. Is there a way
where i
can automatically drag each word out into a new column next to the
original
cell so i can click and drag the concatenate function down to the last
cell?
please help!

-pyager