Oops! I thought I was able to cancel it but alas no

--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
=TRIM(SUBSTITUTE(A1,"Specialty:",""))

--


Regards,


Peo Sjoblom


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=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