deleting text after a certain word

[clcnewtoaccess]

Is there a way to remove all text after a word in a cell.
Example: 1.75" radius per mit.
1.75" radius
Thanks,

 

[LPS]

You can double-click on the cell,move the cursor to the end of the data you
want to delete and press backspace until it is gone. Then press the enter key
to complete the edit.

 

[Fred Smith]

Something like this:
=LEFT(A1,FIND("radius",A1)+5)

Regards,
Fred

 

[Roger Govier]

Hi

Control+H to bring up Find and Replace
Find radius per mit
Replace radius
Replace All

 

[clcnewtoaccess]

Sorry I didn't make myself clear.
I have some 25,000 lines to do this in and sometimes there are more words
after and somethime less.

Thanks,

 

[pmartglass]

I believe you can use the search/replace feature
for the example you listed
pull up the replace menu

search: radius*
replace: radius

that should do it

 

[Jim Thomlinson]

I would be inclined to use a formula such as this...

=LEFT(A1,FIND("radius",A1) + 5)

Where your text is in cell A1.

 

[Jim Thomlinson]

Just to clarify. The reason I would be inclined to use a formula is that I
have an aversion to deleting things. If you delete the trailing text there is
no way to get it back. If somewhere in the 25,000 records some of them go
wrong for some reason or you just want to see what it used to look like then
you are in trouble with a replace.

 

[clcnewtoaccess]

Jim, the 1.75" is not a fixed length it varies from 3 to 7 charachters in
length such as .5", 12.00", 125.00" and so on.

Thanks,

 

[Tom Hutchins]

Jim's formula works regardless of the length of the measurement. In his
example, it will return all the characters in A1 from the first character
through the "s" in the word radius. FIND("radius",A1) returns the position
within the contents of A1 where the word radius begins. The +5 is to include
the rest of the word radius.

Hope this helps,

Hutch