2 Replies Latest reply on Jan 5, 2010 10:12 AM by Dracozhu

    Add Text together, How?



      Add Text together, How?


      I had three fields, two contains with numbers but My setting is Text

      for example, Field 1 =1....10

      Field 2=A,B,C,D.....

      Field 3=1.....100


      I want add them together which is 1A1 or 9A99

      How i can do that?

      I tried to use calc, but they give me back numbers such as 2, 198