Locating character positions with FIND (case-sensitive) and SEARCH (wildcards enabled), and replacing text with SUBSTITUTE and REPLACE.
“6.3 Searching & Replacing: FIND, SEARCH, SUBSTITUTE & REPLACE” is part of Formulas That Do the Work. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
