|  

» Extracting Characters from Text Using Text Formulas

To extract characters from text, use Text category formulas:

Left:
Returns the first character(s) in a text string, based on the number of characters specified.

Mid:
Returns a specific number of character(s) from a text string, starting at the position specified based on the number of characters specified.

Right:
Returns the last character(s) in a text string, based on the number of characters specified.

Len:
Returns the number of characters in a text string.

Screenshot // Extracting Characters from Text Using Text Formulas
Extracting Characters from Text Using Text Formulas


Rate This Tip
12 34 5
Rating: 2.73     Views: 48358
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments