Excel macro to remove suffixes from words

Lengkap Disiarkan Dec 15, 2012 Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

I have a list of words in Excel, many of them with suffixes. I have a list of 170 suffixes that I want to remove from these words. I only want to remove a suffix once, starting with the longest suffix.

So, I just need a macro to do this.

Read cell X.

See the chars in cell X end with any of the suffixes in the list of 170 (starting with the longest ones).

If a match is found, truncate the string in cell X to remove the suffix, and write to word root a new column.

There also is one additional, minor macro I need help with. Should be a breeze for someone who knows Excel macros well.

PHP Kejuruteraan Perisian

ID Projek: #4044519

Tentang projek

4 cadangan Projek jarak jauh Aktif Dec 15, 2012

Dianugerahkan kepada:

phpthebest

Hi, I can start now , please check PM.

$30 USD dalam 0 hari
(30 Ulasan)
4.5

4 pekerja bebas membida secara purata $90 untuk pekerjaan ini

ehsanx

I can do it.

$50 USD dalam sehari
(41 Ulasan)
5.5
diegogarcia0531

Hi, I can do the job, I am ready to start working VBA developer, Excel expert

$30 USD dalam 0 hari
(3 Ulasan)
3.1
parthuji

4 years exp and quality work surity

$150 USD dalam 3 hari
(4 Ulasan)
2.7