How to strip text from a cell

Hello,

I have hundreds of rows of text that all have a unique ID. What I mean is each cell has a name and then before the extension has a ^PRP######. These are all filenames with a unique id attached before the extension.

What i wanted is to strip the ^PRP###### from each cell

is that possible?

thanks (see attached)