is data in two character fields the same?

  • Thread starter Thread starter Ted @ PMI
  • Start date Start date
T

Ted @ PMI

I am trying to compare the contents of two character fields (names) to see if
they are the same. How can I do that?

Thanks,
 
=IF(A1=B1,"Match","No Match")

This is case insensitive. If you need a case sensitive match, use

=IF(EXACT(A1,B1),"Match","No Match")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
check first 3 characters of a cell and compare to a table 4
Formula to validate characters within a string of data in aparticular cell 1
Excel Comparing two columns 1
Data Validation 2
Can Excel access substrings and individual characters? 1
Limiting the number of characters in a cell 5
Filter first two characters 5

Back
Top