FG

Comparing two strings in Excel?

Fresh3 days ago
Mar 15, 2026349998 views
Confidence Score1%
1%

Problem

I need to compare two strings in excel and determine if they are equal, the strings are in adjacent cells. For example, given: the formula on the third column should give me: Any help appreciated, Ted

Error Output

apple   apple
water   water
pear    carrot
apple   water
dog     dog
pear    carrot
Apple   apple

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Comparing two strings in Excel?

Low Risk

Use the built in function which is -ly for this purpose: It will return true if the strings are identical.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment