Need help triming a sentence

[Jim]

Hello:

I would like to trim the following:

Specialty: Allergy & Immunology

to show only:

Allergy & Immunology

What formula can I use for this?

Thanks

 

[Gary''s Student]

With your text in A1, use:

=RIGHT(A1,20)

 

[David Biddulph]

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Excel Nut]

You don't HAVE to use a formula.

If you have multiple rows and you want to delete all the text up to an
including the colon and the space following the colon, simply select
the cells, press CTRL+H, Find "*: " (i.e. asterisk+colon+space) and
Replace All with blank. This assumes there is only one colon in each
cell.

Francis Hayes
www.TheExcelAddict.com

 

[Jim]

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?

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom