Re: Remove duplicate phone numbers on same row
Thank you so much Jindon. Unfortunately I am getting a type mismatch error on the following line when I use it on real data:
txt = Join(Application.Index(a, i, 0), Chr(2))
The data is in Excel table format. Would that make a difference? I tried converting it to a range but that didn't help.
When I try it with the test data I provided it's working but I noticed that with one of the phone numbers it truncated the area code of the firs occurrence of the number.
i.e. 905747899 in Cell H4 becomes 7477899 after I run it.