Text Functions (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Purpose of text functions in Excel
Purpose of text functions in Excel
Manipulate, extract & work with text data
LEFT function purpose
LEFT function purpose
Extract chars from beginning/left of text
RIGHT function purpose
RIGHT function purpose
Extract chars from end/right of text
MID function purpose
MID function purpose
Extract chars from any position within text
MID function unique requirement
MID function unique requirement
Always requires start position & char count
CONCATENATE function purpose
CONCATENATE function purpose
Joins pieces of text together
Alternative to CONCATENATE
Alternative to CONCATENATE
Ampersand (&) operator
LEN function purpose
LEN function purpose
Counts number of chars including spaces
VALUE function purpose
VALUE function purpose
Converts text numbers into actual numerical values
FIND function key characteristic
FIND function key characteristic
Case-sensitive when locating text position