CONCATENATE FUNCTION!

[pyager]

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

 

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

 

[TomPl]

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

Try it, you'll like it.

Tom

 

[pyager]

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

THANKS!!

 

[Bernard Liengme]

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