Capture right text string

**andyp161** · 08-16-2007, 08:01 AM

Hi there

Please can someone advise how I can grab the right-most text string after a space e.g.

North West London NW - I would want to grab 'NW'.

Many thanks

**NBVC** · 08-16-2007, 08:17 AM

Try

=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255)

Where A1 houses original string

**andyp161** · 08-16-2007, 08:19 AM

Thanks very much!!

**Ron Coderre** · 08-16-2007, 08:20 AM

With A1 containing text

This formula returns the text following the last space in that cell:
B1: =TRIM(VLOOKUP(" *",INDEX(RIGHT(" "&A1,ROW($A$1:INDEX($A:$A,LEN(" "&A1),1))),0),1,0))

Does that help?