★0 XP
Question 1 of 10
The SUBSTITUTE function replaces some text in a specified cell with a new string of text. To get a string of text that says "New Jersey", try typing
=SUBSTITUTE(A3, "York", "Jersey")
=SUBSTITUTE(A3, "York", "Jersey")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Minnesota | |||
| 2 | California | |||
| 3 | New York | |||
| 4 | Florida | |||
| 5 | Illinois |
fx