!text,num_bytes!!Returns the specified number of characters from the start of a text string. Use with double-byte character sets (DBCS)!is the text string containing the characters you want to extract!specifies how many characters you want LEFT to return!
text!Returns the number of characters in a text string!is the text whose length you want to find. Spaces count as characters! ...
text!Returns the number of characters in a text string. Use with double-byte character sets (DBCS)!is the text whose length ...
text,number_times!Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string!is ...
text,num_bytes!Returns the specified number of characters from the end of a text string. Use with double-byte character sets ...
text,num_bytes!Returns the specified number of characters from the start of a text string. Use with double-byte character ...
text,num_chars!Returns the specified number of characters from the end of a text string!is the text string that contains ...
text,num_chars!Returns the specified number of characters from the start of a text string!is the text string containing the ...
text,old_text,new_text,instance_num!Replaces existing text with new text in a text string!is the text or the reference to ...
text,start_num,num_bytes!Returns characters from the middle of a text string, given a starting position and length. Use with ...