Cell compare has issue with MAJOR text
Excel 2002 ( 10.6789.6714 ) SP3
when I was attempting to check if two cells had the same text , I was getting false negatives when the two cells compared have the text MAJOR in the cell Is major a keyword and somehow not matching correctly? I have other comparisons which are successfully with MINOR , CRITICAL . I am using the function as follows =EXACT(B2,E2) I also attempted to enter the text manually in two cells and that comparison failed. I was importing data on original attempt. suggestions ? comments ? |
Cell compare has issue with MAJOR text
try:
=Exact(trim(B2),trim(E2)) to remove leading/trailing blanks. "Nfld Son" wrote: Excel 2002 ( 10.6789.6714 ) SP3 when I was attempting to check if two cells had the same text , I was getting false negatives when the two cells compared have the text MAJOR in the cell Is major a keyword and somehow not matching correctly? I have other comparisons which are successfully with MINOR , CRITICAL . I am using the function as follows =EXACT(B2,E2) I also attempted to enter the text manually in two cells and that comparison failed. I was importing data on original attempt. suggestions ? comments ? |
Cell compare has issue with MAJOR text
that worked, thanks ! "Toppers" wrote: try: =Exact(trim(B2),trim(E2)) to remove leading/trailing blanks. "Nfld Son" wrote: Excel 2002 ( 10.6789.6714 ) SP3 when I was attempting to check if two cells had the same text , I was getting false negatives when the two cells compared have the text MAJOR in the cell Is major a keyword and somehow not matching correctly? I have other comparisons which are successfully with MINOR , CRITICAL . I am using the function as follows =EXACT(B2,E2) I also attempted to enter the text manually in two cells and that comparison failed. I was importing data on original attempt. suggestions ? comments ? |
All times are GMT +1. The time now is 01:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com