You can use flash fill to extract initials from name quickly. Watch my video on this topic by using below link.
​Extract initials from names​​​


​Homepage​​​
​MS EXCEL TRAINING​​​