Help With cleaning data to a specific description

[gavinmelville1]

Hello,

I have a data set of ~2500 rows, the data im concerned with is the description. The description has large variations within the data set, i am looking to consolidate the descriptions to a common description.

For example :
*********
Z99 2017 343199 343199 2016/2017 - COLD START CONT 3164199 6290 9754 738 SH831194 SH831194
Z99 1900 381669 381669 2017/2018 - COLD START 3164199 6290 9754 35225 SH831194 SH831194
Z99 1900 381669 381669 2017/2018 - COLD START 3164199 6290 9754 688.08 SH831194 SH831194
Z99 1900 381669 381669 2017/2018 - COLD START 3164199 6290 9754 687.5 SH831194 SH831194


I would want to consolidate the descriptions (2016/2017 - Cold Start Cont.) & (2017/2018 - Cold Start) both to (Cold Start).

This is a simple example as there are many variations within the database.

Notes: Im amateur at VBA but am willing to venture that course

Thank you in Advance!

 

[shift-del]

Hi

=REPLACE(A1,SEARCH("COLD START",A1)-12,12,"")