Comparing text in 2 different cells

[systemdude]

Hi

It is easy to do the above as per https://exceljet.net/formula/compare-two-strings.

My question: Can one do such a comparison without extra spaces in one cell being counted in the comparison? In other words, if the only difference between the 2 cells is an extra space in a sentence, I still want the comparison to say "true".

Thanks.

 

[JoeMo]

Maybe:

=EXACT(TRIM(A2),TRIM(B2))

 

[systemdude]

Many thanks yes that works.

 

[JoeMo]

Many thanks yes that works.

You are welcome - thanks for the reply.