Splitting a Cell

[Mark_Pike]

Afternoon all, I need an excel formula (not text to columns) where by the "PIP010008" is in a single cell on its own Cell content is as follows

APPROVAL REQUIRED: Non-PO Invoice 571316 for Property PIP010008

[#2]

@Mark_Pike 

=RIGHT(A1,LEN(A1)-SEARCH("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

This formula returns the intended result in my example.

[#3]

@Mark_Pike 

If you use 365

= TEXTAFTER(data," ",-1)

will split the entire column 'data' returning the final string of each.