Concat formula is truncating values

Options
FarSideFeb
FarSideFeb Registered Posts: 16 ✭✭✭

Hello,

I am taking one column which contains values that vary in length from 18 - 32 digits, and putting a single tick mark at the beginning of the number, and at the end of the number.

After typing out my formula concat("'",OrderNBR,"'") my new column, "OrderNBR2", contains truncated order numbers. The original OrderNBR column has the data type of string - text, and is not truncated. IS there a way I can put a "cast" or some other feature into my concat formula to prevent the order numbers from truncating?


Operating system used: Windows

Tagged:

Answers

Setup Info
    Tags
      Help me…