Hi,
I'm looking for a formula VBA or UDF to delete/Extract String from multiples ranges if Match Range reference (i haven't see one)
Example:
Range Reference D2:N2 Have a strings--------------------------> 01,02,03,04,05,06,07,08,09,10,11
Range 2 D5:N5 Have Strings ------------------------------------->25,31,40,27,01,12,03,15,06,14,18
As Output need to get Range2 String without the matched ---->25-31-40-27-12-15-14-18
Range 3 D9:N9 Have Strings ------------------------------------->04-18-30-08-29-13-28-15-07-22-02
As Output need to get Range3 String without the matched ---->18-30-29-13-28-15-22
Range 4 D12:N12 Have Strings ------------------------------------->32-33-34-26-05-12-08-06-29-09-16
As Output need to get Range4 String without the matched ---->32-33-34-26-12-29-16
Range 5 D15:N15 Have Strings ------------------------------------->41-02-17-23-10-01-11-15-06-20-04
As Output need to get Range5 String without the matched ---->41-17-23-15-20
In advance Thank you very much!!
Bookmarks