View Single Post
  #9   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 11:26:00 +0100 schrieb Victor Delta:

Thanks again,


I don't know which output you need.
You can also try this formula:
=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",))=1,MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1),MID(A1,FIND("#",SUBSTITUTE( A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)&", "&SUBSTITUTE(A1,MID(A1,FIND("#",SUBSTITUTE(A1, " ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99),""))


Regards
Claus B.


Thanks, that's perfect.

V