Extract last word string

**Shareez Saleem** · 07-06-2015, 05:32 AM

Hi,

Give the best formula to extract the last word strings.

Attached file FYR.

Regards
Shareez

**Ali Kırksekiz** · 07-06-2015, 05:39 AM

Please Login or Register  to view this content.

This in an array formula and so must be confirmed with CTRL+SHIFT+ENTER and not just ENTER then pull down.

Or

Please Login or Register  to view this content.

**samba_ravi** · 07-06-2015, 05:42 AM

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,","," ")," ",REPT(" ",256)),256))
try this and copy towards down

**popipipo** · 07-06-2015, 05:45 AM

=TRIM(RIGHT(SUBSTITUTE(A2;",";REPT(" ";250));250))
or this "normal" formula

**Richard Buttrey** · 07-06-2015, 05:51 AM

...if there are always only ever three commas then

Please Login or Register  to view this content.

edit...just seen popipipo's which is 9 characters shorter. Damn!

**Shareez Saleem** · 07-06-2015, 06:20 AM

That's my TEAM; always Quick and Accurate.

Thanks a ton.

Re: Extract last word string