Splitting a Cell

Copper Contributor

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 Replies




This formula returns the intended result in my example.

splitting a cell.png


If you use 365

= TEXTAFTER(data," ",-1)

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