Hi,

There are several way but it depends upon what you are doing. For example
=IF(A1="a",1,IF(A1="b",2,IF(A1="c",3,4)))
is ok if you and have a few conditions but soon runs out of capacity if you
have lots.
Can you be a bit more precise about what you are doing.

Mike

"Batshon" wrote:

hi all,
Am trying to convert A, b, C (text) into 1,2,3
Can anybody help me in putting the right formula?
Cheers..