Extract the Last Word only

[Sam_Krausz]

This is my Text 1781740134 - appe6FfiZjCiI7hzM - tblxf90kn7ktZOfxF - Submitted

How can I extract the last word only “Submitted”?

Which formula do I need to use?

[manish_mandot]

@Sam_Krausz

1781740134 - appe6FfiZjCiI7hzM - tblxf90kn7ktZOfxF - Submitted

Do this. you will get the last word.

[Sam_Krausz]

Oh wow

Now can you please help to extract the following two items?

[manish_mandot]

@Sam_Krausz I am going to charge you for this

Here is the solution.

[manish_mandot]

Based on your use case, you can make it dynamic as well.

[Sam_Krausz]

Meaning? I don’t understand your answer here