Forum Discussion
Splitting a Cell
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 ...
=RIGHT(A1,LEN(A1)-SEARCH("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
This formula returns the intended result in my example.