text functions Flashcards
1
Q
return certain no. of characters from the left
A
LEFT
2
Q
return certain no. of characters from the right
A
RIGHT
3
Q
return a certain no. of characters from with a texrt
A
MID
4
Q
stick texts together
A
CONCATENATE
5
Q
finding the no. of characters in a word
A
LEN (short for length)
6
Q
finding the position of the first character of a text string within a second string….
A
SEARCH
7
Q
TEXT- formats no. given a certain format to text
A
.
8
Q
how to capitalize first word in a sentence, all others not..
A
PROPER()
9
Q
remove all spaces from texts, leave only spaces between individual words in a text string
A
TRIM
