Differentiating between "A" and "A*"

[pvans267]

Good morning all,

I wonder if someone could help me.

I am currently comparing two spreadsheets of student grades. However, I have discovered that Excel treats A* and A as identical results.

I tried to do a Search and Replace for A* to 0, however, once again Excel replaced all the "A" results as well!!

Could someone give me a method to overcome this?

Thank you so much

Paul

 

[VoG]

Try replacing A~* with 0.

 

[jim may]

Find What: A~*
Replace with: 0

 

[pvans267]

Hi Jim,

Thank you so much - worked like a charm.

Kind Regards,

Paul