Convert the data in the cell to "Yes"

[Yuris]

Hi
I have a date in Excell with the parts numbers, such as:

112C342

443DF11

RR34909


The are scattered over the column and not in each cell (the last one is in the around 10,000 cell).
I want to onvert them to "Yes" word.
How I can do it?
Thank you!

 

[JohnnyTightlips]

not sure I understand you correctly.

You want to replace all the part numbers with the word "Yes"?

If so, select the column they are in, go to Find and replace (ctrl+H)

In the find text field type "* " (no quotation marks)
In the replace with field type "Yes" (no quotation marks)

 

[Yuris]

Thanks!!!
It is so simple!