what if there is more than one blank space - For example

Daniel criag stiefel

Thanks

"Trevor Shuttleworth" wrote:

=MID(A1,FIND(" ",A1)-1,1)

Regards

Trevor


"dstiefe" wrote in message
...
I have a column with rows of names for example:

danil stiefel
jae lowed
dist help

I want to count, starting from the right, and when I reach the first blank
space I want to capture the letter of the space before the empty space and
the letter.

Thank you