text functions Flashcards Preview

Excel 1 > text functions > Flashcards

Flashcards in text functions Deck (9)
Loading flashcards...
1

return certain no. of characters from the left

LEFT

2

return certain no. of characters from the right

RIGHT

3

return a certain no. of characters from with a texrt

MID

4

stick texts together

CONCATENATE

5

finding the no. of characters in a word

LEN (short for length)

6

finding the position of the first character of a text string within a second string....

SEARCH

7

TEXT- formats no. given a certain format to text

.

8

how to capitalize first word in a sentence, all others not..

PROPER()

9

remove all spaces from texts, leave only spaces between individual words in a text string

TRIM