Pull Single Character

[Sumits96]

Hi All,

I am trying to pull a single character from a cell. However, I am doing this manually right now and would like automate this. Is there a formula that will let me call out a single character at the end. I have given an example below.

Smith, Jane G - I want this to equal 1
Smith, Jane - I want this to equal 0

As you can see, I am trying to put in a formula that will allow me to see all the cells that have middle initial. For all the ones that don't, the value will be 0. Please let me know if anyone can help.

Thanks,

[Domski]

Try:

=ISNUMBER(FIND(" ",RIGHT(A1,LEN(A1)-FIND(", ",A1)-1)))*1

Dom

[TMS]

If the cell is A1,

=MID(A1,LEN(A1)-2,1)=" "

Regards