I have column A with random data alpha and alpha numeric. Column C with specific orderly data. I need to search value of column C exists in any section of column A. If yes then it should highlight in column B and update the the value.
<tbody>
Aptus Utilitie A7MWUO5V
A7MWUO5V
A3IPM3117C...