Hi All,
I need to compare 2 cells with numbers & return the result as TRUE or FALSE.
I have tried ISERROR & EXACT function but the input not returning TRUE because
one of the source have space (refer attached book)
FYI, the number scanned from a barcode which by default have space in it.
Thank you in advance :-)
Use TRIM function to eliminate space in both cells
=NOT(ISERROR(SEARCH(TRIM(A2),TRIM(B2))))
Quang PT
Hi bebo021999,
The formula OK but sorry i forgotten to include that there's same
input in SOURCE2 doesn't have special characters like %,@ & etc.
So i need formula to compare just numbers & alphabet only
Refer attached file
Assuming that the cell that should contain the formula is C8 and that the result should be TRUE, try:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you JeteMC, good solution
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks