Converting string of letters to Number

[sebkavam]

Hi,
I'd like to convert a string of letters in excel to a unique number. I
that possible?
Thank

 

[Guest]

Probably need a bit more info as far as sample data goes but you could try
something like this:
=IF(A1="abc",5)
If you put this formula in a cell and if abc is in cell A1 it will put a 5
in your cell.

 

[Gord Dibben]

Probably, but more detail would be beneficial.

What sort of string?

What sort of number to be used in what context?


Gord Dibben MS Excel MVP

 

[sebkavam]

Basically, I have words like "movies", "arts", etc... and I want t
associate to each of these words a unique number. These numbers do no
have to be a sequence as long as two different words cannot b
associated with the same number

 

[Gord Dibben]

My question is..............what will you do with the numbers that are
associated with the strings?

Easy enough to return a number to a cell using a formula.

Will you want to use them for calculations?

For a list?


Gord Dibben MS Excel MVP

 

[sebkavam]

just for a list.
thank

 

[Sandy Mann]

associate to each of these words a unique number

Is is in fact possible to calculate a *unique* number? What I am thinking
about is that when I have used the sheet password breaking Macro it returns
another set of letters that fulfill the number calculated by the original
password. As both sets of letters calculate to the same number protecting
the sheet, the number is obviously not unique. If Bill Gates can't return a
unique number from a set of letters.numbers then I am sure that I would fail
to do so as well.

Just a thought.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk