This could certainly be done with a formula or a script in Excel. Do you have a sample of the 3000 rows. This is so we can know how to extract the string.

Thanks