Text functions are useful for manipulating strings in your data, for example, distributing the first, middle, and last names from a cell into three separate columns.
This article demonstrates how to use combinations of the following text functions to extract and copy name components into separate cells.
Function Syntax
LEFT LEFT(text, num_chars)
MID MID(text,start_num,num_chars)
RIGHT RIGHT(text, num_chars)
SEARCH SEARCH(find_text,within_text,start_num)
LEN LEN(text)
No comments:
Post a Comment