I need to remove all characters in a cell after the first word. Anyone know how to do this?
If you assume that a space is the division between words you can use something like this.
if you have a sentence with a comma after the first word it will return it as well, however. You can insert this in an adjoining cell and paste the result. or if you want a macro to do that, it is fairly simple to adapt.