SHARE
TWEET

One-line answer to http://stackoverflow.com/a/11248029/18511

a guest Jun 28th, 2012 70 Never
  1. LEFT(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)&" "&IF(ISERR(FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))+1)),MID(MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),1,FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))-1),TEXT(MID(MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),1,FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))-1),"00")&TEXT(MID(MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))+1,FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))+1)-FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))-1),"00")&TEXT(MID(MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))+1)+1,FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))+1)+1)-FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255),FIND(".",MID(A1,SEARCH(CHAR(8), SUBSTITUTE(A1," ",CHAR(8),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255))+1)-1),"00"))&".pdf"
RAW Paste Data
Top