I need to know the way to substitute multiple times. Right now I'm running the equation, "=SUBSTITUTE(Sheet1!A$1,"blue",Sheet1!B1)". I need to substitute 3 charters from Sheet1a1 instead of just "blue".
I need to know the way to substitute multiple times. Right now I'm running the equation, "=SUBSTITUTE(Sheet1!A$1,"blue",Sheet1!B1)". I need to substitute 3 charters from Sheet1a1 instead of just "blue".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks