Replace partial text string from column based on value
I need to replace the value of column A with a value depending on part of the content of the cell in column A.
So let’s say…
A2 = “Company-a2”, I want to replace only the ‘a’ with a ‘c’, making the result “Company-c2” BUT if…
A2 = “Company-b2”, I want to replace only the ‘b’ with a ‘d’, making the result “Company-d2”
Pulling my hair out with this one 🤪
I need to replace the value of column A with a value depending on part of the content of the cell in column A.So let’s say…A2 = “Company-a2”, I want to replace only the ‘a’ with a ‘c’, making the result “Company-c2” BUT if…A2 = “Company-b2”, I want to replace only the ‘b’ with a ‘d’, making the result “Company-d2″Pulling my hair out with this one 🤪 Read More
