Are those 500 cells in a single column?

Then I'd insert a column to the right and use a formula like:

=MID(B1,FIND(" ",B1)+1,LEN(B1))

(Assuming that the character that separates the word is a space.

Leslie wrote:

How can I delete a word from up to 500 cells at a time? It's the first word
of the text in the cell.

Thanks!
Leslie

--

Dave Peterson