deleting text after a certain word
 

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

deleting text after a certain word
 

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.
--
LPS


"clcnewtoaccess" wrote:

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

deleting text after a certain word
 

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

Regards,
Fred

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

deleting text after a certain word
 

Hi

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

--
Regards
Roger Govier

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

deleting text after a certain word
 

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,
--
clcnewtoaccess


"LPS" wrote:

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.
--
LPS


"clcnewtoaccess" wrote:

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

deleting text after a certain word
 

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


"LPS" wrote:

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.
--
LPS


"clcnewtoaccess" wrote:

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

deleting text after a certain word
 

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

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

Where your text is in cell A1.
--
HTH...

Jim Thomlinson


"clcnewtoaccess" wrote:

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

deleting text after a certain word
 

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.
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

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

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

Where your text is in cell A1.
--
HTH...

Jim Thomlinson


"clcnewtoaccess" wrote:

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

deleting text after a certain word
 

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,
--
clcnewtoaccess


"Jim Thomlinson" wrote:

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

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

Where your text is in cell A1.
--
HTH...

Jim Thomlinson


"clcnewtoaccess" wrote:

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

deleting text after a certain word
 

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

"clcnewtoaccess" wrote:

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,
--
clcnewtoaccess


"Jim Thomlinson" wrote:

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

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

Where your text is in cell A1.
--
HTH...

Jim Thomlinson


"clcnewtoaccess" wrote:

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