Help me!
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?
|