if statement help!

C

cutsygurl

I need to make an if statement that looks at only part of the cell.
Example
A1 B1
487A365 =if(A1="487A", 1, 2)

so i need B1 to say 1. The last three digits dont matter, only th
first four.
If anyone can help me that would be great. :)

Thanks
Tin
 
Top