LinkBack URL
About LinkBacks
I would like to be able to use OR in substitute, to say remove red or blue or green if it appears in cell.
A1
red tiger
B1
green turtle
C1
blue fish
=SUBSTITUTE(A1,("red "or"blue "or"green "),"")
I would like to be able to use OR in substitute, to say remove red or blue or green if it appears in cell.
A1
red tiger
B1
green turtle
C1
blue fish
=SUBSTITUTE(A1,("red "or"blue "or"green "),"")
Last edited by seanjacob; 09-23-2010 at 05:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks