SOLVED

Formula help required multiple if

Copper Contributor

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 (A2,1,5,"Close"),REPLACE (A2,1,4,"Closed"))

Except Pending-ask all text are changing 

I need to change that one as well my output should exactly like this "Closed-ask"

 

2 Replies
best response confirmed by Nandhu19940 (Copper Contributor)
Solution

@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
1 best response

Accepted Solutions
best response confirmed by Nandhu19940 (Copper Contributor)
Solution

@Nandhu19940 If all your data is in seperate cells then this formula will work

 

=+REPLACE(A1,1,FIND("-",A1,1)-1,"Closed")

View solution in original post