Hi there;
I am trying to do a very basic comparison between two text strings to see if they are exact or not. Please reference my setup:
1st text string:
A1: ALBERTA EDUCATION
A2: =LOWER(A1) which produced alberta education (lower case)
A3: pasted A2 as special paste "values"
2nd text string:
A4: ALBERTA EDUCATION
A5: =LOWER(A1) which produced alberta education (lower case)
A6: pasted A5 as special paste "values"
A7:=EXACT(A3,A6) which gave me a "false" response
Some other background, the original information was all capitalized, so I used the =LOWER function to convert to lowercase (I understand the =LOWER formula is case sensitive). I than did a "paste special" as a "value" from the =LOWER formula. Both A3 and A6 cells are formated as "text". Help, this should be pretty straight forward but I am struggling. Any suggestions out there?
Thanks for listening
Mark
I am trying to do a very basic comparison between two text strings to see if they are exact or not. Please reference my setup:
1st text string:
A1: ALBERTA EDUCATION
A2: =LOWER(A1) which produced alberta education (lower case)
A3: pasted A2 as special paste "values"
2nd text string:
A4: ALBERTA EDUCATION
A5: =LOWER(A1) which produced alberta education (lower case)
A6: pasted A5 as special paste "values"
A7:=EXACT(A3,A6) which gave me a "false" response
Some other background, the original information was all capitalized, so I used the =LOWER function to convert to lowercase (I understand the =LOWER formula is case sensitive). I than did a "paste special" as a "value" from the =LOWER formula. Both A3 and A6 cells are formated as "text". Help, this should be pretty straight forward but I am struggling. Any suggestions out there?
Thanks for listening
Mark
Last edited: