Hi there, could someone please help me? I would like to find a text string in the column A and index the value after the string.

For example: somewhere in the column A is a text "value: 800 USD" , so I would like to find the text and index the characters after the ": " in the cell C5. Therefore in the cell C would be "800 USD"

I am including sample file here: smpl.xlsx

Any help will be appreciated. Thank you.