Concatenate Strings - merge values IF...

[emukiss10]

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]H[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]data[/TD]
[TD]Nova 33/12[/TD]
[TD]Rset[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]data[/TD]
[TD]Anders 9 [/TD]
[TD]Dublin[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]data[/TD]
[TD]17/11[/TD]
[TD]Barns[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]data[/TD]
[TD]Legal 1[/TD]
[TD]Ostar[/TD]
[/TR]
</tbody>[/TABLE]

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.

 

[Legacy 143009]

May be you should check: https://stackoverflow.com/questions/29855647/check-if-cell-contains-non-alpha-characters-in-excel

 

[emukiss10]

Thank You for Your reply but I still need VBA besides that formula from stack does not work for me.