Delete word from multiple cells
 

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

Delete word from multiple cells
 

Hi Leslie. Go to Edit - Replace and in the Find what line type in the word
to be replaced. You might want to include a space if there is one between
the first and second word. Leave the Replace with line blank. HTH

Sincerely, Michael Colvin


"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

Delete word from multiple cells
 

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