Hello friends,
I don't want the dash sign in my address. I want to modify the case 7 which will ignore dash sign while concatenate.
Please help to solve my problem.
Mukesh
Hello friends,
I don't want the dash sign in my address. I want to modify the case 7 which will ignore dash sign while concatenate.
Please help to solve my problem.
Mukesh
Hi Mukesh,
change this line
with this![]()
.Value = x & vbLf & y(0)
![]()
.Value = Replace(x & vbLf & y(0), "-", "")
Hi nilem,
Thank you. It solved my problem and giving desire output.
Thank you very much.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks