I'm not sure that I know what you mean about substitutions.
The code should run on the sample data you posted / I think I replicated.
Bedtime here now. If you / I / both are still confused tomorrow then I will need further clarification of your real data set.
OK, I think my signature just about sums it up. I need clarification of how your data is set up.
The options are...
You provide a specific verbal description
You post representative screenshots
You post a link to a sample file on a third party host such as Dropbox
You PM me and we arrange to exchange a file by email
You resign your current job and get yourself another that does not involve spreadsheets
I 'get a life' and maybe, take up golf instead
SHOOT! THAT did not work at all!! I'll try again, data is this:
Columns and data (ea column is 100px wide, like almost, below!), in NOW state: A--------B--------C--------D-------- word
Columns and data, in DESIRED state: A--------B--------C--------D-------- word--------------x
Is that easy, or possible for some formula / function / magic to:
if a certain "word" is in A1, Excel will add a letter x in C1?
The only thing I'd need is that the x be placed on the same row as the "word", but in column C.
Please let me know, @Snakehips, if you are still with your first coffee and toast! Thank you so much!!