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