Renaming Data...

C

cdavidson

I have data in column A:

a
b
c
a
c
c

What I need to do is use a formula in column B which will turn all the a's
in 1's, all the b's into 2's, and the c's into 3's etc. (i.e. output in
column B would be...)

1
2
3
1
3
3


Is this possible with a formula?

Thanks for the help.
 
C

cdavidson

Thanks, worked perfect. Never heard of the 'code' function before.

One other question... how do I search this site for all the postings I
submitted?

Thanks again!
 
Top