Hi,
I'm trying to put the following 3 formulas into 1
=REPLACE(E2,FIND("ITEMTITLEHERE",E2),13,F2)
=REPLACE(E2,FIND("DESCRIPTIONHERE",E2),14,AE2)
=REPLACE(E4,FIND("IMAGEHERE",E4),9,AG4)
I manages to get a good person to solve the first 2 into:
=REPLACE(REPLACE(E2,FIND("ITEMTITLEHERE",E2),13,F2),FIND("DESCRIPTIONHERE",REPLACE(E2,FIND("ITEMTITLEHERE",E2),13,F2)),14,AE2)
But I'm struggling getting the 3rd addition to work without errors. The code would be very appretiated. The structure of the formula makes my brain bubble.
Thanks
Dave
Bookmarks