RaqForum 28 No.
379 View  • 
     ...

Calculate the Difference of Two White-space-separated Strings

 
string split(9) set operation(2) difference(1)

Problem description & analysis

We have an Excel file Book1.xlsx:

A

B

1

A3 B27 A23 DQ8

A3 A23 DR16

 We are trying to calculate the difference between A1 and B1 in C1. The desired result is as follows:

A

B

C

1

A3 B27 A23 DQ8

A3 A23 DR16

B27 DQ8

Solution & explanation

Load add-in ExcelRaq.xll in Excel, and

Select cell C1 and enter the following formula in it to =esproc("=(?1.split("""")\?2.split("""")).concat("""")",A1,B1) to get the result.

Q & A Collection

https://stackoverflow.com/questions/63567248/identifying-different-values-between-two-strings-of-text-in-excel


string split(9) set operation(2) difference(1)
 
 •  379 View  •