Hi guys! Happy New Year!
I have a little problem.
I have 2 columns with adresses and cities. Almost always there is a street number with street name in column H and City in column J. But not always. Sometimes a little village do not have street names, just numbers and I need to merge that cells with cities.
<tbody>
</tbody>
In this example in row 3 I would like a script to add City name before number in column H sou it would be:
Barns 17/11
So, whenever in column H there is only number I need to copy city name before it.
I need VBA script to do this.
Best Regards
W.
I have a little problem.
I have 2 columns with adresses and cities. Almost always there is a street number with street name in column H and City in column J. But not always. Sometimes a little village do not have street names, just numbers and I need to merge that cells with cities.
| A | H | J | |
| 1 | data | Nova 33/12 | Rset |
| 2 | data | Anders 9 | Dublin |
| 3 | data | 17/11 | Barns |
| 4 | data | Legal 1 | Ostar |
<tbody>
</tbody>
In this example in row 3 I would like a script to add City name before number in column H sou it would be:
Barns 17/11
So, whenever in column H there is only number I need to copy city name before it.
I need VBA script to do this.
Best Regards
W.
