I’m trying to change a string of text inside a cell using a button.
I wish to replace the “xxx” in the highlighted column to a number related to the project (derived from a column in a different table).
I did my best at writing a formula inside the button using the “replace” function but with no success (formula seen in attached JPG).
In the following example all the “xxx” should be replaced with “003” so that the full name will be “a-003-100-dem” (for the first row), “a-003-101-binuy” (for the second row), etc.
Would appreciate some help.
If the Hebrew is an issue, I’ll upload a table in English.
Thx in advance,
Table from which the project number is taken: