Forum Discussion

Copper Contributor

Jun 05, 2023

Solved

How to find the difference between two text cells

Hi everyone and thanks for taking your time Is there any software that can help extract the difference value between two text cells, like in the image below?

excel

Formulas and Functions

Macros and VBA

Detlef_Lewin
Jun 05, 2023
aliadm1490
=TRIM(SUBSTITUTE(A2,B2,""))

peiyezhu

Bronze Contributor

Feb 22, 2024

=WEBSERVICE("https://e.anyoupin.cn/eh3/?regreplace~\s*(" & substitute(b2," ","|") & ")\s*~ ~" & A2)