Other Functions
MID(text, start_num, num_chars): Returns a specific number of characters from a text string, starting at the position you specify.
Example: =MID(“Hello World”, 7, 5) returns “World”.
FIND(find_text, within_text, [start_num]): Finds one text value within another.
Example: =FIND(“World”, “Hello World”) returns 7.
REPLACE(old_text, start_num, num_chars, new_text): Replaces part of a text string with a different text string.
Example: =REPLACE(“Hello World”, 1, 5, “Hi”) returns “Hi World”.
SUBSTITUTE(text, old_text, new_text, [instance_num]): Substitutes new text for old text in a text string.
Example: =SUBSTITUTE(“Hello World”, “World”, “Excel”) returns “Hello Excel”.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com