Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

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

By: a guest on Jun 28th, 2012  |  syntax: None  |  size: 2.06 KB  |  views: 67  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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"