G
Guest
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
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