Filter the content of a Cell

[Andrew.Trevayne]

Hi Everyone,
Im back again with another question.

On a Cell. Is it possible to filter the content and copy it in a different cell?

Assuming on Cell A1 I have this --> TEAMS ABCDEFG J:\ O:User Name

And then on Cell A2 I only want as result --> User Name or any other name that appears on cell A1.
The O actually means Owner so this is sort of constant on all cells.

Appreciate your help.Thanks in advance.

[DonkeyOte]

Do you perhaps mean:

A2:
=REPLACE(A1,1,FIND("O:",A1&"O:")+1,"")

If not, I would suggest posting a sample file with plenty of examples (and desired results) to better illustrate the requirements.

[Andrew.Trevayne]

Thank you very much, this is perfect.
Appreciate it