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