How to match contents in 2 separate cells?

Closed
kerrie - Updated on Jan 30, 2018 at 07:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 30, 2018 at 11:40 AM
I have data in 2 separate cells. I need a formula that will pick out the first 3 characters from each cell and show if a match (true/false). Any help?
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 30, 2018 at 11:40 AM
Hi Kerrie,

Let's say the 2 seperate cells are A1 and B1:
=IF(LEFT(A1,3)=LEFT(B1,3),TRUE,FALSE)

Best regards,
Trowa
0