Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

@Mark_Pike 

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

 

This formula returns the intended result in my example.

splitting a cell.png

@Mark_Pike 

If you use 365

= TEXTAFTER(data," ",-1)

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