first letter of every word with a . afterwards

[justme123]

I I am looking for a formula with extracts the first letter of every word in a cell
J(2-1000) = | Peter Carl S. D. |

and puts out

K(2-1000) | P. C. S. D. |

thanks a lot 4 ure help

[NBVC]

This would take care of to 4 separate strings....

in K2,

Please Login or Register  to view this content.

copied down.

[justme123]

This would take care of to 4 separate strings....

in K2,

Please Login or Register  to view this content.

copied down.

thanks but it doenst work

J2,FIND is marked by excel

[NBVC]

It works fine for me...

see attached.

[Paul Edwards]

I'm trying to do something similar but different.

I just want the initials of a persons name...

eg

John Smith
Fred Nurk
Billy Bunting

to return

JS
FN
BB

Just cant seem to make it work. Can someone help please?

Cheers,

Paul

[Paul Edwards]

Problem solved
http://www.excelforum.com/showthread.php?t=608510

(Should'a hit the search key first )

Paul...