I have data with symbols like "|" and "~" and ":" from H to say N column.
With VBA (using switch statement) get,
In Column B and C: Concatenate data with and without "|" from respective rows
In Column D and E: Concatenate data with and without "~" from respective rows
In Column F and G: Concatenate data with and without ":" from respective rows
Excel 2010
<tbody>
</tbody>
With VBA (using switch statement) get,
In Column B and C: Concatenate data with and without "|" from respective rows
In Column D and E: Concatenate data with and without "~" from respective rows
In Column F and G: Concatenate data with and without ":" from respective rows
Excel 2010
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||
2 | 1 | Get data with | | Get data without | | Get data with ~ | Get data without ~ | Get data with colon | Get data without colon | data1 | data2 | data3 | data4 | data5 | data6 | data7 |
3 | 2 | | | 1 # ~1 a; : | ~1 | 1 # a; : | | : | 1 # ~1 a; | | 1 | # | ~1 | a; | : | | | |
4 | 3 | 1 4 0:01 (b:a) # | 1 4 0:01 (b:a) # | 0:1 (b:a) | 1 4 # | 1 | 4 | 0:01 | (b:a) | # | ||||
5 | 4 | x| x| | x| x| | x| x| | x| | x| | ||||||||
6 | 5 | 5 a | 5 a | 5 a | 5 | a |
<tbody>
</tbody>
Sheetprofit