Concatenate Two Columns and Enter Result to Another Column
Problem description & analysis
Below is Excel file Book1.xlsx:
| A |
B |
C |
|
| 1 |
1 |
A |
|
| 2 |
2 |
B |
|
| 3 |
3 |
A |
|
| 4 |
4 |
B |
|
| 5 |
5 |
A |
|
| 6 |
6 |
B |
|
| 7 |
7 |
A |
|
| 8 |
8 |
B |
|
| 9 |
9 |
A |
|
| 10 |
10 |
B |
We are trying to join values of two column A and column C and enter the result to column B. Below is the desired result:
| A |
B |
C |
|
| 1 |
1 |
1A |
A |
| 2 |
2 |
2B |
B |
| 3 |
3 |
3A |
A |
| 4 |
4 |
4B |
B |
| 5 |
5 |
5A |
A |
| 6 |
6 |
6B |
B |
| 7 |
7 |
7A |
A |
| 8 |
8 |
8B |
B |
| 9 |
9 |
9A |
A |
| 10 |
10 |
10B |
B |
Solution & analysis
Load add-in ExcelRaq.xll to Excel, and then
Enter the following formula in cell B1: =esproc("=int(?1)/?2",A1,C1) and drag B1 down to B10 to get results.
https://stackoverflow.com/questions/63627727/concatenate-2-columns-into-new-column-in-vba
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL
