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