Forum Discussion
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...
Here is a formula that should work in all versions of Excel.
In could be streamlined Excel in Microsoft 365.
=LEFT(A2, FIND("-", A2))&CHAR(CODE(MID(A2, FIND("-", A2)+1, 1))+2)&MID(A2, FIND("-", A2)+2, 10)