Need help triming a sentence
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
--
David Biddulph
"Jim" wrote in message
...
Hello:
I would like to trim the following:
Specialty: Allergy & Immunology
to show only:
Allergy & Immunology
What formula can I use for this?
Thanks
|