trying to locate the first space and display the text to the right of it.

I87 = Intermediate Water elemental
I am displaying the first word in a cell here
=IF(I87="","",LEFT(I87,FIND(" ",I87,1)))

Trying to display second and third words in another cell.
I have several different combinations In I87 that are generated randomly.
I87 = Minor Fey
I87 = Intermediate Water elemental
I87 = Major Red dragon
what I am going for is a cell that splits up power level and type into two different cells
so I can index a chart for what is displayed.
what is the formula for this please and thanks in advance.
trying to stay away from macros

hi weedfiend. try:
=IFERROR(TRIM(MID(SUBSTITUTE($I87," ",REPT(" ",100)),1+(COLUMNS($J87:J87)-1)*100,100)),"")

if you're interested to know how it works, concept is similar to sheet 12 of the file of my link in my signature; Tips & Tutorials

This will break out all word when copied across, with the data in A1 - adjust as needed...
=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+1,LEN($A1)))

Not sure you uploaded the right workbook? (or maybe wrong references?)

I87=Gold Dragon
I88=Intermediate Ogre
I89=Intermediate

IF it is "ogre" you want to extract, then try this...
=TRIM(MID(SUBSTITUTE($I87," ",REPT(" ",LEN($I87))),LEN($I87)*(COLUMN()-8)+1,LEN($I87)))
for subsequent words, copy it across