Using EXACT function to compare text strings

ROBITMP

New Member
Joined
Jan 19, 2007
Messages
14
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
 
Last edited:

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
What is in A3 and A6? Is that where your formulas are and then you're pasting the values in A2 and A5 or what?

I don't understand the point of this comparison, but check to make sure that neither of your initial values have extraneous spaces.

Excel Workbook
AB
1ALBERTA EDUCATION
2alberta education
3alberta education
4ALBERTA EDUCATION
5alberta education
6alberta education
7TRUE
8TRUE
Sheet1
 
Last edited:
Upvote 0
Hi there hotpepper;

I have just modified my message, the original message I prepared came out looking like a dog's breakfast (yah I know....rookie)
These two text strings are customer names (among 32,000 other names from an extract). I am comparing some master data with collection data to see if there are any anomalies.

Hope my new formatting is more clear.

Regards....
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top