Delete word from multiple cells

L

Leslie

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
 
M

Michael

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
 
D

Dave Peterson

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.
 
Top