Sedang Disiapkan

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 lebih lanjut: 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, match macro, write macro word, write macro excel, need excel macro

Tentang Majikan:
( 430 ulasan ) Willowbrook, United States

ID Projek: #4044519

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
ashugarora

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)
0.0