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