Route Rota A B C D E 56 R1 A Spiderman day off Spiderman Spiderman Spiderman Spiderman Spiderman 8 R2 B superman superman day off superman superman superman superman 21 R3 C cat woman cat woman cat woman day off cat woman cat woman cat woman 30 R4 D tom tom tom tom day off tom tom 69 R5 E ed wood ed wood ed wood ed wood ed wood day off ed wood F1 Reserve F fall out boy fall out boy fall out boy fall out boy fall out boy fall out boy day off Hi I want to replace the word REST for the cell value which contains "fall out boy". This is a duty roster that I am working on and the original formula was =IF($C3=$G$1,"day off",$D3) . Now I want to put "fall out boy" as cover on Spiderman's day off and of course the rest of the people. I have tried using nested functions however I am coming up short on this one. IS there any way this can be done?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Substituting text in a cell for another piece of text

Thread starter North for Short
Start date Dec 4, 2020

North for Short

New Member

Dec 4, 2020

Route Rota				A	B	C	D	E

56	R1	A	Spiderman	day off	Spiderman	Spiderman	Spiderman	Spiderman	Spiderman
8	R2	B	superman	superman	day off	superman	superman	superman	superman
21	R3	C	cat woman	cat woman	cat woman	day off	cat woman	cat woman	cat woman
30	R4	D	tom	tom	tom	tom	day off	tom	tom
69	R5	E	ed wood	ed wood	ed wood	ed wood	ed wood	day off	ed wood
F1	Reserve	F	fall out boy	fall out boy	fall out boy	fall out boy	fall out boy	fall out boy	day off

Hi I want to replace the word REST for the cell value which contains "fall out boy". This is a duty roster that I am working on and the original formula was =IF($C3=$G$1,"day off",$D3) . Now I want to put "fall out boy" as cover on Spiderman's day off and of course the rest of the people. I have tried using nested functions however I am coming up short on this one. IS there any way this can be done?