Extract specific value from rows

Hi All. I have a column that contains a project's attributes and I would like to extract a specific value from the attribute (specifically, whatever text comes right after the words "Project"). Is it possible to do this through VBA?

You can do it with a formula:

=RIGHT(A1,LEN(A1)-(FIND("Project",A1)+6))

Assuming A1 is the cell that contains the text.

If there is a space after the word "Project" in the original text that you don't want to carry over change +6 to +7

That would do it! Thanks!