match 2 cell with chinese character value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concantenate then index match 2
Referring to a cell by using another cell for the row number 6
Conditional Indexing 2
Index and named ranges selecting difficulty 7
Index and Match 8
matching data to dates - please help 7
Autofilter using cell reference 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12

Back
Top