I gang

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.

Færdigheder: PHP, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 430 bedømmelser ) Willowbrook, United States

Projekt-ID: #4044519

Tildelt til:

phpthebest

Hi, I can start now , please check PM.

$30 USD in 0 dage
(30 bedømmelser)
4.5

4 freelancere byder i gennemsnit $90 for dette job

ehsanx

I can do it.

$50 USD på 1 dag
(41 bedømmelser)
5.5
diegogarcia0531

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

$30 USD in 0 dage
(3 bedømmelser)
3.1
parthuji

4 years exp and quality work surity

$150 USD in 3 dage
(4 bedømmelser)
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 Mere

$150 USD in 12 dage
(0 bedømmelser)
0.0