Apologies, missed a closing parenthesis after the second Left function

=IF(LEFT(A1)="B",1,IF(LEFT(A1)="A",2,IF(LEFT(A1)=" G",3,"")))

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

Rather than having to type the whole description of what is in cell
A1, you could just use the first character as in the formula below
Enter in A2
=IF(LEFT(A1)="B",1,IF(LEFT(A1="A",2,IF(LEFT(A1)="G ",3,"")))

--
Regards

Roger Govier


"sike11 via OfficeKB.com" <u21678@uwe wrote in message
news:6c83ffa63fd02@uwe...
Hi All,

Please help!!

My problem is the following:

I have text in a column like this

A1
BTEC National Diploma
AS Economics
GCSE Maths

What I would like to happen in the next column is a formula like the
following:

IF A1 = "BTEC National" then A2 = 1
ELSE
IF A1 = "AS" then A2 = 2
ELSE
IF A1 = "GCSE" then A2 = 3

I am a little stumped as to how achieve this. Any ideas?

Thank you in advance!

Mary.

--
Message posted via http://www.officekb.com