converting text to numbers

[cassy1988]

i have a set of values that is ranges from a,b,c. i need to change the values of these numbers so a =1, b=0 and c=0. i can't do it manually as there is over 300 a's,b's and c's. is there a quick way to change these in excel?
thanks for your help!!

[VBA Noob]

Select Column > Ctrl + H > find dialog box = A replace dialog box = 1

then repeat for next two criteria

VBA Noob

[cassy1988]

WOW! thank you so much i searched for so long, you're a life saver!

[VBA Noob]

Glad it helped. Here's a formula that could do the same

If data in A1 enter this in B1 and drag down then paste special values and delete column A

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1),"a",1),"b",0),"c",0)

VBA Noob