comparison of tow non numeric data

[Hrishi]

Hello
I want to compare 2 cells containing non numeric data along with identification of differences excluding blank spaces. example

Providing & fixing external false ceiling ( visible from Bull pen area ) at an angle as per detailed drawings from the main Portal frame and using framework used for gypsum sheets of 12.5 mm thk of gyproc or equivalent make.

Providing & fixing external false ceiling ( visible from Bull pen area ) at an angle as per detailed drawings from the main Portal frame and using framework used for gypsum sheets of 15 mm thk of gyproc or equivalent make. Complete

FALSE​

​

in above data there are slight changes in wording, using cell 1 = cell 2 will show true and false, but how to identify or highlight quickly the exact difference in words?

 

[JamesCanale]

If A1 and B1 is your two sentences, this formula will put "**" around whatever words are different in both.

=LET(a,TEXTSPLIT(A1,," "),b,TEXTSPLIT(B1,," "),c,ISNA(MATCH(a,b,0)),d,IF(c,"**"&a&"**",a),e,TEXTJOIN(" ",TRUE,d),f,ISNA(MATCH(b,a,0)),g,IF(f,"**"&b&"**",b),h,TEXTJOIN(" ",TRUE,g),HSTACK(e,h))

Providing & fixing external false ceiling ( visible from Bull pen area ) at an angle as per detailed drawings from the main Portal frame and using framework used for gypsum sheets of **12.5** mm thk of gyproc or equivalent make.

Providing & fixing external false ceiling ( visible from Bull pen area ) at an angle as per detailed drawings from the main Portal frame and using framework used for gypsum sheets of **15** mm thk of gyproc or equivalent make. **Complete**

 

[Hrishi]

If A1 and B1 is your two sentences, this formula will put "**" around whatever words are different in both.

=LET(a,TEXTSPLIT(A1,," "),b,TEXTSPLIT(B1,," "),c,ISNA(MATCH(a,b,0)),d,IF(c,"**"&a&"**",a),e,TEXTJOIN(" ",TRUE,d),f,ISNA(MATCH(b,a,0)),g,IF(f,"**"&b&"**",b),h,TEXTJOIN(" ",TRUE,g),HSTACK(e,h))

Providing & fixing external false ceiling ( visible from Bull pen area ) at an angle as per detailed drawings from the main Portal frame and using framework used for gypsum sheets of **12.5** mm thk of gyproc or equivalent make.

Providing & fixing external false ceiling ( visible from Bull pen area ) at an angle as per detailed drawings from the main Portal frame and using framework used for gypsum sheets of **15** mm thk of gyproc or equivalent make. **Complete**

thanks alot,