match 2 cell with chinese character value
 

hi,
i tried to use =if(d3=e3,"match", "not match") but even both cell have
exactly the same chinese character but still return not match.
i even try =if(text(d3)=text(e3),"match","not match") but still cannot.
any advice.
thanks

match 2 cell with chinese character value
 

You may have spaces or other unprintable characters along with your expected
characters. Try =LEN(D3) and =LEN(E3) to see whether the cells contain as
many characters as you expect. If you want to check exactly which character
you have at which space in the cell, try =CODE(MID(D3,n,1)) to see the nth
character in the cell.
--
David Biddulph

"AskExcel" wrote in message
...
hi,
i tried to use =if(d3=e3,"match", "not match") but even both cell have
exactly the same chinese character but still return not match.
i even try =if(text(d3)=text(e3),"match","not match") but still cannot.
any advice.
thanks