How to match contents in 2 separate cells?

Closed
kerrie - Updated on Jan 30, 2018 at 07:35 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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?

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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