how to extract last word from a string of more than two words also when string ending with

**Zeb1980** · 10-25-2016, 06:06 AM

Hello all

Could you please help me to make a formula to extract last word from a string of more than two words also when string is ending with a space as well.

COLLAR COLLAR BELT COAT COAT
COLLAR COLLAR BELT DRESS DRESS
COLLAR COLLAR COAT
COLLAR COLLAR COAT COAT

I would like to extract last word but they all are ending with space.

Thank you

**AlanY** · 10-25-2016, 06:16 AM

try this

=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",500)),500))

**Tony Valko** · 10-25-2016, 06:32 AM

Here's another one...

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),75))

**Zeb1980** · 10-25-2016, 06:42 AM

Thank you so much guys

the both formulas work perfectly

kind regards

**Tony Valko** · 10-25-2016, 04:45 PM

You're welcome. Thanks for the feedback!

how to extract last word from a string of more than two words also when string ending with

LinkBack

Thread Tools

Rate This Thread

Display

how to extract last word from a string of more than two words also when string ending with

Re: how to extract last word from a string of more than two words also when string ending

Re: how to extract last word from a string of more than two words also when string ending

Re: how to extract last word from a string of more than two words also when string ending

Re: how to extract last word from a string of more than two words also when string ending

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract 5th string onwards but exclude 6th string onwards if found a specificlist of words

[SOLVED] Extract all the words from a string for processing, while leaving string intact.

Extract Last Two Words of a string

Extract n words from string

Extract a string of text between certain words

UDF to extract first three words from string

Extract last two words from string

Bookmarks

Bookmarks

Posting Permissions