Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i type Chinese character in Office | New Users to Excel | |||
Remove ' character from copied excel cell to match data | Excel Discussion (Misc queries) | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Excel 2003 traditional chinese to simplified chinese | Excel Discussion (Misc queries) | |||
Can I use Excel to convert Chinese character into Unicode? | Excel Discussion (Misc queries) |