I have been trying to come up with a formula that will read each cell in a
column and copy & paste only the cells that contain numbers with .50. I can
seem to properly configure the formula to read any whole number as long as it
contains .50 in it. I want these vnumbers pasted into a seperate column.

=IF(D21="*"+"0.50"),(D21),("")

Thank you very much for your assistance.