A complicated one... is this even possible?

[RWABristol]

Hey forum folks,

I have a problem. I need to replace:

HERE in B2 with the data in C2
HERE 2 in B3 with the data in C3
HERE 3 in B4 with the data in C4
HERE 4 in B5 with the data in C5
HERE 5 in B6 with the data in C6

And I need to do the same for every cell in column B. Is this possible?

For context, I work for an arts charity and I need to upload loads of artworks to our website. Column B is supposed to be the product description for each artwork. I have very little time, so I'm hoping someone can help me Thanks!

 

[shknbk2]

Hi and welcome to the forum.

HERE in B2 with the data in C2
HERE 2 in B3 with the data in C3
HERE 3 in B4 with the data in C4
HERE 4 in B5 with the data in C5
HERE 5 in B6 with the data in C6

First, I think you mixed up the cell data. In my solution below, I used the following:
HERE in B2 with the data in C2
HERE 2 in B2 with the data in D2
HERE 3 in B3 with the data in E2
HERE 4 in B3 with the data in F2
HERE 5 in B3 with the data in G2

In H2, I have the formula below. The formula can be copied down to get the rest of the rows.

Book1
	B	C	D	E	F	G	H
1		Title	Artist	Medium	dimensions	edition
2	Title HEREArtist HERE 2Medium HERE 3Dimensions HERE 4Edition HERE 5	Namredips	Joe	ink, acrylic	Height: 7cm x width: 7cm	n/a	Title NamredipsArtist JoeMedium ink, acrylicDimensions Height: 7cm x width: 7cmEdition n/a
Sheet1

Cell Formulas
Range	Formula
H2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"HERE 5",G2),"HERE 4",F2),"HERE 3",E2),"HERE 2",D2),"HERE",C2)

 

[RWABristol]

You have saved me HOURS during a really stressful, busy week. I can't thank you enough!

You were right, I did mix up the cell data, but your formula did exactly as I'd hoped