how to get the middle name

[zomex]

how can i get the middle name like "george w bush" how can i get W

 

[Bill Kuunders]

go to

<data><text to columns><delimited><spaces>