Hello:

I would like to trim the following:

Specialty: Allergy & Immunology

to show only:

Allergy & Immunology

What formula can I use for this?

Thanks

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

=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

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

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

=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

=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

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

Earlier I suggested
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
but it looks as if some news servers are not picking up all the messages.
--
David Biddulph

"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