Microsoft Office Tutorials and References
In Depth Information
Working with Text
Working with Text
CONCATENATE joins several text strings into one text string.
CONCATENATE joins text. However, you’ll most likely want the text separated, so the two
examples in Figure 2.6 in cells E5 and E6 use a quote separater to apply text or space between the
characters. The ampersand sign also adjoins text as an alternative to the CONCATENATE function.
Capitalize the first letter in a text string and any other letters in text that follow any character
other than a letter by using the PROPER function.
The PROPER function cleans text and applies uppercase to the first letter in a text string—referred
to as initial caps. Notice the example in Figure 2.6.
UPPER converts text to uppercase.
The UPPER function reverts all text within a cell to upper case. Notice the example in Figure
2.6. To do the opposite, use the LOWER function to convert all text to lowercase.
The RIGHT function returns the last character or characters in a text string.
The RIGHT function combined with the LEN and FIND functions can be used to extract text
strings of any size. Where the cell referenced is C14, the RIGHT function looks for the text,
and the LEN function counts the text in the right text string, minus the numeric position of the
space in quotes using the FIND function.
MI Use MID to return a specific number of characters from a text string, starting at the position
The MID function can be used to extract left names or characters combined with the FIND
function. The MID function counts the characters starting with the first character, and the FIND
function subtracts one character space from the space to return the left text string result as
shown in cell D18 of Figure 2.6.