Excel macro to remove suffixes from words

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.

Kemahiran: PHP, Kejuruteraan Perisian

Lihat lagi: excel macro remove suffix string, i need help with excel, excel macro to word, need help with excel, need help excel, remove from, just remove, Breeze, list suffixes, write macro, excel additional, php macro, php excel read, php excel macro, excel macro php, php string remove, macro excel write word, macro match excel, want help excel macros, excel longest match, need excel macros, write 170 words, remove suffix string php, php remove suffix string, php remove string

Tentang Majikan:
( 430 ulasan ) Willowbrook, United States

ID Projek: #4044519

Dianugerahkan kepada:


Hi, I can start now , please check PM.

$30 USD dalam 0 hari
(30 Ulasan)

4 pekerja bebas membida secara purata $90 untuk pekerjaan ini


I can do it.

$50 USD dalam sehari
(41 Ulasan)

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

$30 USD dalam 0 hari
(3 Ulasan)

4 years exp and quality work surity

$150 USD dalam 3 hari
(4 Ulasan)

Hi, I have a team of 11 designers and 14 developers, we develop all kind of websites and we guarantee complete job satisfaction by providing quality work. We always believe in building long term relationships with Lagi

$150 USD dalam 12 hari
(0 Ulasan)