Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/

=REGEX.SUBSTITUTE(A1,"[a-z,0-9]","")


"JockW" wrote:

Hi
Is it possible to use a function to extract only words in capital letters in
a cell?
So, for instance from "IS IT POSSIBLE to use a function" would return IS IT
POSSIBLE and ignore the rest.

Answers on a postcard please....
--
tia