Converting letters to numbers (N and Y to 0 and 1)

Hi there-

I have a column of data that consists of Ns and Ys - I need to convert it to numbers so that N=0 and Y=1. I've tried Googling and searching this forum, but can't seem to find a solution that I can get to work.

Any help would be much appreciated!

You could create a new series, and use "if statements".

i.e.
if(a2 = "N", 0 , 1)

Andy, you're a genius!

I feel like a dweeb - that solution was so simple, it didn't even occur to me! Haha... it worked like a charm, thanks so much.