Extract all words from a cell

[jenjoyx99]

Hello,

I have a long list of database which contains numbers and words. I would like to extract all the words into a another cell.
Here is the example of list.

382-B CAP ADAPTER 3002441
HSL2 (10-PER)BULK 3002580
WL SK-14 14" SLEEVEY5114L
2-5/8" 1"DR 12PT STD SOCKET
EBC-62 .008 SS2 3/4IN DIA
07377 NUT SETTER 1/4 MA
20449 SCKT 1/4 FMALE SQ
WE BB-8-12HP BUSHING
WE BE-2-25HP ADAPTOR
7-PC 12PT METRIC BOX WRE
ANCHOR ID-3 51 IND TIP DRILL
WE WME-8-42 LIGHT BULB
SS STRGHT THRU PLUG X 1/
1/4" DR SCRDRVR 1/4" TIP CHROME



Result:
B1: CAP ADAPTER
B2: BULK
B3: SLEEVEY
and so on.

I appreciate your help. Thank you!

 

[pgc01]

Hi
Welcome to the board

Sorry, but your post is very incomplete. How can excel know what the words are?

For ex.

HSL2 (10-PER)BULK 3002580

How can excel know that:
HSL is not a word
PER is not a word
BULK is a word

??

For ex. not even I, that am human, know what you consider words in:

20449 SCKT 1/4 FMALE SQ

So, in conclusion, you must post the logic that allows excel to look at a sequence of letters and decide: this is a word or this is not a word.

 

[jenjoyx99]

Thank you very much for your input.