On Sun, 1 Feb 2009 22:00:05 -0800, Deepak
wrote:

I need to assign codes to words for e.g. Product Master would need a code
like "PM"

If you happen to have Longre's free morefunc.xll add-in installed, then you
could use:

=MCONCAT(REGEX.MID(A1,"\b\w",INTVECTOR(WORDCOUNT(A 1),1)))

See http://xcell05.free.fr/morefunc/english/index.htm or Google if the site is
not up
--ron