AnsweredAssumed Answered

insert phone number  file to file

Question asked by moogie on May 20, 2013
Latest reply on May 21, 2013 by 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?  

Outcomes