Thread
:
Help with Excel Formula?
View Single Post
#
9
Posted to microsoft.public.excel.misc
Victor Delta[_2_]
external usenet poster
Posts: 199
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
Reply With Quote
Victor Delta[_2_]
View Public Profile
Find all posts by Victor Delta[_2_]