You could use a regexp to do this. Search for help on the VBscript RegExp
object.
Or just split on spaces and check each word to see if it's like "*d"
--
Tim Williams
Palo Alto, CA
"KH_GS" wrote in
message ...
Hi All,
I have a column containing phrases. I need to match each word of the
phrase that end with letter "d", copy such words and paste onto a new
column.
Do I have to delimit the words by spaces first so I have only 1 word in
each cell?
How can I do it?
--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile:
http://www.excelforum.com/member.php...o&userid=32920
View this thread: http://www.excelforum.com/showthread...hreadid=527411