You do have to watch out for wild cards (* and ?) and the escape character.

If you want to replace an asterisk character, use ~* in the from string.
If you want to replace a question mark, use ~? in the from string.
If you want to replace a tilde (~), use ~~ in the from string.



tlee wrote:

Many thanks for your help.

How about if the string searching? such as "4~8¢J"

Thanks again!
Tlee

The simplest option for one-off changes is to use search and replace.
Select the entire column and use the search-replace function, three times.



--

Regards,
Nigel




"tlee" wrote in message
...
Hi all,

Could anyone help me how to check the column content by different
condition?

If the content of the cell is "Father" then replace it to "1" in the same
column.
If the content of the other cell is "Mother" then replace it to "2" in
same column.
If the content of another cell is "Sister" then replace it to "3" in the
same column.

Besides, how can I implement this checking by using Marco?

Thanks,
Tlee


--

Dave Peterson