what would be the best way to extract content to the left of the last space

[johnmerlino]

Hey all,

if I have something like this:

fjifj fijfij frjfj idjfij


I'm just curious what would be the best way to extract the last group of characters and only return this:

fjifj fijfij frjfj

Thanks for response.

 

[Krishnakumar]

Hi,

There may be better ways..

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

HTH

 

[Scott Huish]

=left(a1,find("`",substitute(a1," ","`",len(a1)-len(substitute(a1," ","")))))