I have something like this:
| Column A | Column B |
|---|---|
| It is going to impactnnVALUE: nnADD(…) | SUBTRACT(…) |
Basically I want to take what is in COL B and update what’s in COL A after the part “VALUE: nn”.
So COL C should look like this:
| Column C |
|---|
| It is going to impactnnVALUE: nnSUBTRACT(…) |
I have multiple rows of this so I just gave one 1 example here I’d like to do this for rows 2-100.
Not sure how to replace just a part of the column
New contributor
user24856638 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1