Thread: Help with Excel Formula?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
  
Posts: 199
Default Help with Excel Formula?
In article , says...

Hi Victor,

Am Sat, 15 Aug 2015 09:40:08 +0100 schrieb Victor Delta:

Many thanks, that's very helpful. I was hoping it might be possible to
make the split on the last (of n) spaces to cope with the 'Cllr Peter M
Smith' who may crop up one day...!

to find always the last part of the string try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)


Regards
Claus B.

Claus

Thanks again,

V
Reply With QuoteReply With Quote