Forum Discussion
Solved
Formula help required multiple if
Close-CSK, Close-making, open-tax, pending-ask Above are text I have in my data, I need to change the text before hypen to "closed" for all. My formula : IF (OR (MID (A2,1,4)="Close"),REPLACE (A...
Nandhu19940 If all your data is in seperate cells then this formula will work
=+REPLACE(A1,1,FIND("-",A1,1)-1,"Closed")
Nandhu19940 If all your data is in seperate cells then this formula will work
=+REPLACE(A1,1,FIND("-",A1,1)-1,"Closed")
- Thanks lot Devendra ☺ it works fine
