Splitting a Cell

Question

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

oliverscheurich · Answer

Mark_Pike&nbsp;=RIGHT(A1,LEN(A1)-SEARCH("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))&nbsp;This formula returns the intended result in my example.

peterbartholomew1 · Answer

Mark_Pike&nbsp;If you use 365= TEXTAFTER(data," ",-1)will split the entire column 'data' returning the final string of each.&nbsp;

Forum Discussion

Splitting a Cell

Share

Resources