duplicate word

  1. S

    How to obtain duplicate word where the each cells in one column are text strings?

    In one column, here are the sample input which goes on until about 4,000 rows: ALIANZA ESTRATEGICA BOTTARI SPA VIA TAVOGLOERE BUNZL MEDIDIS SA SOCIETE HENKEL 3 Susses 3M BKK 3M 3M 3m 3M - BOND 3M HKG 3M - INNOCOM 3M - MEANING 3M - NARITA 3M - PAID 3M - PODA 3M - TRANS 3M ( TJ ) 3M ANR 3M...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top