I have a cell A and its value is
In another cell B, I want its value to be the value in cell B but all
1 should be replaced by
I - value in cell B should be
What is the function to use in this case?
I believe you are looking for the Substitute function:
What you're looking for, is the "replace" function. If cell A contains 122abb12, and you want the 1's to be replaced to I in cell B but keep the rest: the replace function could look somewhat like this: =REPLACE(A1;"1";"I")