How to match contents in 2 separate cells?

kerrie - Jan 30, 2018 at 06:03 AM - Latest reply: TrowaD 2355 Posts Sunday September 12, 2010Registration dateModeratorStatus May 17, 2018 Last seen
- 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?
See more 

Your reply

1 reply

TrowaD 2355 Posts Sunday September 12, 2010Registration dateModeratorStatus May 17, 2018 Last seen - Jan 30, 2018 at 11:40 AM
0
Helpful
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
Respond to TrowaD