Hi everyone, I need to compare the strings contained in 2 adjacent columns (row by row) and highlight the similar part.
I tried with some VBA code I found online but it doesn't work well for me, as my strings don't contain any spaces or other characters.
I attach some of the lines.
Thank you all!!
I tried with some VBA code I found online but it doesn't work well for me, as my strings don't contain any spaces or other characters.
I attach some of the lines.
Thank you all!!
Cartel1 | ||||
---|---|---|---|---|
A | B | |||
1 | Column 1 | Column 2 | ||
2 | pantotexsrl | pantotex | ||
3 | hgisrl | abbigliamentohgi | ||
4 | modamilanosrl | modamilanosrl | ||
5 | bluediffusionsrl | bluediffusion | ||
6 | centromodaruggierobyarconfabbigliamentosumisura | centromoda2 | ||
7 | lafogliasrl | lafogliasrl | ||
8 | franzeseabbigliamentosrl | franzeseabb | ||
9 | euforiakajalproduzioneabbigliamentodonnabyfdpsrl | fdpsrl | ||
10 | stigmatieltd | stigmati | ||
11 | ghirafsrl | ghirafsrl | ||
12 | cucitex2srlindumentiusati | cucitex2011 | ||
13 | produzioneeingrossoabbigliamentodonnamonicamorelli | monicamorelliofficial | ||
14 | atelebabrideelenabarba | elenabarbasposa | ||
15 | goldjeanssrl | goldjeans | ||
16 | lauclecreazionidiguarinoanna | laucle | ||
17 | machodiffusion2ndstreetshowroom | machodiffusion | ||
18 | sitelliskinlaboutletrivadirenobologna | sitellishop | ||
19 | nuovaorizzontisrl | orimodasrl | ||
20 | soelservicesncditagliatielisaebenatisonia | soelservice | ||
21 | ellebisrl | alanellebi | ||
22 | plissettaturacaporalidivalmorritomasecsas | plissettaturacaporali | ||
23 | confezionievi | eviconfezioni | ||
24 | deantonicarnia | dacarnia | ||
25 | gheshandgoldsrl | commercialegheshgold | ||
26 | implosedabbigliamentouomo | implosed | ||
27 | centrodeca | decaroma | ||
28 | dmyddmsrlu | dmsrl17 | ||
29 | aretesrl | aretemoda | ||
30 | ingrossoabbigliamentosportivoroma100x100cotone | 100x100cotonesrls | ||
31 | mpmartoranosrl | mpmartoranosrl | ||
32 | martinettireadivisescolasticheabitiprimacomunione | martinettirea | ||
33 | lineaecostume | lineacostume | ||
34 | blive | blivepromozionale | ||
35 | fashiontradesrl | fashiontrade | ||
36 | mffsrlmattmodafashionfursrl | mffsrl | ||
37 | futurasasdirizzivitoec | futuravitorizzi | ||
38 | annarockmilano | annarockmilano | ||
39 | almarsrl | almaringrossoabbigliamento | ||
Foglio1 |