software

Hi there again.
Thank you guys for very helpful information.

I am continuing my work with a prospective clinical study for my project.
You taught me how to add text to the existing records. Would you mind to help
me with several tips on deleting small parts existing text in the column?

Ex:
ID Patient Tissue type Code
10 Snow, John Plasma 10SJ-P
11 George, Roy T-cells 11GR-T

I want to delete quot;Pquot; and quot;Tquot; for all samples in the Code column. The
expecting result should look like this:

Ex:
ID Patient Tissue type Code
10 Snow, John Plasma 10SJ
11 George, Roy T-cells 11GR

Thanks a lot!!!
DanielHi usmleboy,
If D2 shows 10SJ-P and E2 has =LEFT(D2,LEN(D2)-2) then in E2 you should
see 10SJ, (provided Column E is not formatted as Text).
You could then double click the fill handle, which is a fine cross that
only appears when the fat cross cursor is positioned over the bottom
right corner of the selected cell, then the formula in E2 is filled
down to the bottom of your data. You could then copy column E and
editgt;paste specialgt;paste values over the old values in column D.
Ken JohnsonAssuming your text is in column 1, use the following formula in a helper
column.

=LEFT(A1,FIND(quot;-quot;,A1)-1)

quot;usmleboyquot; wrote:

gt; Hi there again.
gt; Thank you guys for very helpful information.
gt;
gt; I am continuing my work with a prospective clinical study for my project.
gt; You taught me how to add text to the existing records. Would you mind to help
gt; me with several tips on deleting small parts existing text in the column?
gt;
gt; Ex:
gt; ID Patient Tissue type Code
gt; 10 Snow, John Plasma 10SJ-P
gt; 11 George, Roy T-cells 11GR-T
gt;
gt; I want to delete quot;Pquot; and quot;Tquot; for all samples in the Code column. The
gt; expecting result should look like this:
gt;
gt; Ex:
gt; ID Patient Tissue type Code
gt; 10 Snow, John Plasma 10SJ
gt; 11 George, Roy T-cells 11GR
gt;
gt; Thanks a lot!!!
gt; Daniel
gt;

Just add a column and a formula of

=LEFT(D2,FIND(quot;-quot;,D2)-1)

and copy down.

Copy that column, then Editgt;Pastespecialgt;Values, the delete the old column.

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;usmleboyquot; gt; wrote in message
news
gt; Hi there again.
gt; Thank you guys for very helpful information.
gt;
gt; I am continuing my work with a prospective clinical study for my project.
gt; You taught me how to add text to the existing records. Would you mind to
help
gt; me with several tips on deleting small parts existing text in the column?
gt;
gt; Ex:
gt; ID Patient Tissue type Code
gt; 10 Snow, John Plasma 10SJ-P
gt; 11 George, Roy T-cells 11GR-T
gt;
gt; I want to delete quot;Pquot; and quot;Tquot; for all samples in the Code column. The
gt; expecting result should look like this:
gt;
gt; Ex:
gt; ID Patient Tissue type Code
gt; 10 Snow, John Plasma 10SJ
gt; 11 George, Roy T-cells 11GR
gt;
gt; Thanks a lot!!!
gt; Daniel
gt;
Daniel,
click the edit menu, find type quot;10SJ-Pquot; search by column, click replace type
quot;10SJquot;, click find next, click replace or replace all.
Hope this helps.

On Fri 01/06/06 22:56:01, usmleboy gt; wrote:
gt; Hi there again.
gt; Thank you guys for very helpful information.
gt;
gt; I am continuing my work with a prospective clinical study for my project.
gt; You taught me how to add text to the existing records. Would you mind to help
gt; me with several tips on deleting small parts existing text in the column?
gt;
gt; Ex:
gt; ID Patient Tissue type Code
gt; 10 Snow, John Plasma 10SJ-P
gt; 11 George, Roy T-cells 11GR-T
gt;
gt; I want to delete quot;Pquot; and quot;Tquot; for all samples in the Code column. The
gt; expecting result should look like this:
gt;
gt; Ex:
gt; ID Patient Tissue type Code
gt; 10 Snow, John Plasma 10SJ
gt; 11 George, Roy T-cells 11GR
gt;
gt; Thanks a lot!!!
gt; Daniel
gt;