You're welcome, Connie. I'd made it slightly shorter by using just
LEFT(C2), rather than LEFT(C2,1), but the result should be the same.
--
David Biddulph

"Connie Martin" wrote in message
...
Luke, Pete and David, thank you so much! You all had the same answer and
it
works fabulously. Connie

"Connie Martin" wrote:

How would I write this IF statement:
If C2 begins with 4 put "P", if C2 begins with 7 put "S", otherwise put
nothing?

Thank you so much. Connie