Discussions

Expand all | Collapse all

Excel like ""Value"" function

  • 1.  Excel like ""Value"" function

    Posted 07-26-2018 00:30
    I have Field A, Field B and Field C which is the  result of concatenating Field A and Field B. ( All are text fields)  Is there an Excel like "Value" function so that I can get rid of Field A and Field B and Field C stays intact.


  • 2.  RE: Excel like ""Value"" function

    Posted 07-26-2018 02:04
    When you have a formula field like a formula text field and change the field type to a text field, then the previously calculated value will the populated to the text field.  But then going forward, that field will be a text data entry field .....


  • 3.  RE: Excel like ""Value"" function

    Posted 07-27-2018 11:50
    Thanks. It worked perfectly