Compare first characters of two distinct columns in excel

Navigation
0

Is there any function in excel that allows me to compare the first n characters of text I want? 

Por exemplo

Tenho a palavra Joaquim e Joana, comparo por "Joa" e ele me retorna verdadeiro ou falso.
    
asked by anonymous 25.09.2018 / 16:12

1 answer

2

Formula Used:

Resultobtained:

    
25.09.2018 / 16:43
Validation if any form input was changed problem with nav in css