Menu

Text Functions

With InteractiveCalculator you have access to the Excel text functions your're used to. Notice that you need to use the TRIM functions on the fields to turn them into Text, as they're normally assigned a number value inside formulas.

LEFT( TRIM(' @NumberField '), 2 )

Returns the left 2 characters of the NumberField

RIGHT( TRIM(' @NumberField '), 2 )

Returns the right 2 characters of the NumberField

MID( TRIM(' @NumberField '), 3, 2 )

Returns the 2 characters of the NumberField starting from the 3rd character

LEN( TRIM(' @NumberField ') )

Returns the number of characters of the NumberField

Need Help?
Can't find the answer in the help docs? We are quick to answer and friendly :) Thanks! We'll be back with a reply soon.
Send