Use SUBSTITUTE function; (case sensitve)

For replacing string use
=TRIM(SUBSTITUTE(A2,"Fox",)

For replacing the word "Fox".
=TRIM(SUBSTITUTE(" " & A2 & " ", " " & "Fox" & " "," "))
'The Quick Brown Fox Foxer' will be converted to 'The Quick Brown Foxer'

If this post helps click Yes
---------------
Jacob Skaria


"Razzak" wrote:

Please help me. I would like to separate one word from a cell.

Example : Cell A2 = The Quick Brown Fox

Question-1: How to separate "Fox" from Cell A2?
Question-2: How to separate "Brown" from Cell A2?