...
Calculate the Difference of Two White-space-separated Strings
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.