3 Replies Latest reply on May 21, 2013 7:56 AM by moogie

    insert phone number  file to file

    moogie

      Title

      insert phone number  file to file

      Post

           Case(Length(CellT) = 7;Left(CellT;3) & "-" & Right(CellT;4);(Length(CellT) = 10); "(" & Left(CellT;3) & ") " & Middle(CellT; 4; 3) & "-" & Right(CellT;4);"error")

           used above calc for phone number - trying to "set field" a phone number from one file to another file -  doesnt work any suggestions?