How to extract single letter from the whole word in excel 2007

[Vimal]

Hi Friends !

I have been facing a problem with excel formula.
The formula I've used : REPLACE(d!F11,2,20,CONCATENATE(MID(d!F11,3,1),MID(d!F11,5,1)))


I have to extract code of the person name. e.g. I want <VNB> for <V N Bhatt>.and my formula works nice to that.
But sometimes it is written as <Vimal N Bhatt> OR <Vimal Navnit Bhatt> and my formula will not extract the required code <VNB>.
I want first letter of the word must be extracted and I don't know how to form the formula for that.

I need help from the excel experts, please.

 

[strollin]

Try this:

=CONCATENATE(MID(A1,1,1),MID(A1,FIND(" ",A1,1)+1,1),MID(A1,FIND(" ",A1,1+FIND(" ",A1,1))+1,1))

This separates the three names into 3 parts using the blanks between them, then takes the first letter of each part and concatenates them together to come up with "VNB". This example assumes the name is in cell A1, adapt as needed.

 

[Vimal]

Thanks ! Strollin
Your formula returns me the value just as I needed
Thanks for helping so nicely.