1 | cell_context | search_text | new_text | occurrence | Result | Formula | |
---|---|---|---|---|---|---|---|
2 | Google Docs | ogle | od | 1 | Good Docs | =SUBSTITUTE(A2, "ogle", "od", 1) | |
3 | Google Docs | o | a | 3 | Google Dacs | =SUBSTITUTE(A3, "o", "a", 3) | |
4 | Spreadsheet | e | E | SprEadshEEt | =SUBSTITUTE(A4, "e", "E") | ||
5 | Spreadsheet | e | E | 2 | SpreadshEet | =SUBSTITUTE(A5, "e", "E", 2) | |
6 |