Can someone please advise, how can I extract a date from a cell which
contains a date and a text.

FEDERAL HOME LN BKS CONS BD 3%0 Callable 11/11/07@100

FEDERAL NATL MTG ASSN BNCHMRK 3

I would like to have one cell contain a date 11/11/07 if it is there else
"none callable is there's no date.

FEDERAL NATL MTG ASSN BNCHMRK 3

also, how can I have a cell display only company name and not the rest of
the text.

FEDERAL HOME LN BKS

FEDERAL NATL MTG ASSN

Thank you in advance for your help