Excel Formula Palooza 1

in Excel:   
        “splitting on a space”
example:
                A                                           B                                                 C
nano dwarf, very small                      nano                                 dwarf, very small
nano dwarf, very small                   =LEFT(A1,FIND(” “,A1)-1)                      =MID(A1,FIND(” “,A1,1)+1,255)

in Excel:
      ~ is a special character, so special in fact, that you can’t find and replace it w/o escaping it with itself !
               so Find what: ~~   and Replace with: †  WORKS!!

in Excel:   
        “folding multiple columns into a single string”
example:
          A            B          C           D                 E                               F 
         Sir      Walter      P.       Mitty         Esquire       Sir Walter P. Mitty, Esquire
         Sir       Walter       P.       Mitty         Esquire         =CONCATENATE(A1,” “,B1,” “,C1,” “,D1,”, “,E1)
a bit more refined:
=CONCATENATE(TRIM(A1),” “,TRIM(B1),” “,TRIM(C1),” “,TRIM(D1),”, “,TRIM(E1))

maybe something more common:
          A               B                        C                                       D
       CITY            ST            POSTAL CODE
    Baltimore      MD             21234-5529            Baltimore, MD  21234-5529
    Baltimore        MD             21234-5529           =CONCATENATE(TRIM(A5),”, “,TRIM(B5),”  “,TRIM(C5))