=TRIM(SUBSTITUTE(A1,"Specialty:",""))

--


Regards,


Peo Sjoblom


"Jim" wrote in message
...
This is a great formula, but some of my data have more than 20 characters.
Is there a formula that will trim the specialty: and leave the rest of the
data?



"Gary''s Student" wrote:

With your text in A1, use:

=RIGHT(A1,20)

--
Gary''s Student - gsnu200909


"Jim" wrote:

Hello:

I would like to trim the following:

Specialty: Allergy & Immunology

to show only:

Allergy & Immunology

What formula can I use for this?

Thanks