How can I use an Excel formula to move multiple cell contents into designated parts of another cell?

In CB 5, which looks like this:

<ul> <li><span id="product_description"> Cell J5</span><span id="product_description"></span></li> </ul> <p><strong>Fits Models</strong></p> <p>Cell CC5</p> <p><strong>OEM Cross Reference</strong></p> <p>Cell CD5</p> <p><strong>Specification</strong></p> <p>Cell CE5</p> <p><strong>Cross Sells</strong></p> <p>Cell CF5</p> <p><strong>Additional Information:</strong></p> <p>Cell CG5</p>


Is there a way to Replace "Cell J5" with the actual contents of Cell J5?
Is there a way to Replace "Cell CC5" with the actual contents of Cell CC5?
Is there a way to Replace "Cell CD5" with the actual contents of Cell CD5?
Is there a way to Replace "Cell CE5" with the actual contents of Cell CE5?
Is there a way to Replace "Cell CF5" with the actual contents of Cell CF5?
Is there a way to Replace "Cell CG5" with the actual contents of Cell CG5?
Sample.csv
ScooterMcGee75Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
="<ul> <li><span id=""product_description"">"&J5&"</span><span id=""product_description""></span></li> </ul> <p><strong>Fits Models</strong></p> <p>"&CC5&"</p> <p><strong>OEM Cross Reference</strong></p> <p>"&CD5&"</p> <p><strong>Specification</strong></p> <p>"&CE5&"</p> <p><strong>Cross Sells</strong></p> <p>"&CF5&"</p> <p><strong>Additional Information:</strong></p> <p>"&CG5&"</p>"
0
 
ScooterMcGee75Author Commented:
Thank you Saqib,

In CB2, which looks like this:

<p><strong>Fits Models</strong></p> <p>CC2</p> <p><strong>Description</strong></p> <p>J2</p> <p><strong>OEM Cross Reference</strong></p> <p>CD2</p> <p><strong>Specification</strong></p> <p>CF2</p> <p><strong>Cross Sells</strong></p> <p>CE2</p> <p><strong>Additional Information:</strong></p> <p>CG2</p>


Is there a way to Replace "CC2" with the actual contents of Cell CC2?
Is there a way to Replace "J2" with the actual contents of Cell J2?
Is there a way to Replace "CD2" with the actual contents of Cell CD2?
Is there a way to Replace "CE2" with the actual contents of Cell CE2?
Is there a way to Replace "CF2" with the actual contents of Cell CF2?
Is there a way to Replace "CG2" with the actual contents of Cell CG2?
0
 
Saqib Husain, SyedEngineerCommented:
I am sorry, do you still need a response?
0
 
ScooterMcGee75Author Commented:
=”<p><span style="text-decoration: underline;"><strong>Fits Models</strong></span></p> <p>”&CC50&”</p> <p><span style="text-decoration: underline;"><strong>Description</strong></span></p> <p>”&J50&”</p> <p><span style="text-decoration: underline;"><strong>OEM Cross Reference</strong></span></p> <p>”&CD50&”</p> <p><span style="text-decoration: underline;"><strong>Specification</strong></span></p> <p>”&CF50&”</p> <p><span style="text-decoration: underline;"><strong>Cross Sells</strong></span></p> <p>”&CE50&”</p> <p><span style="text-decoration: underline;"><strong>Additional Information:</strong></span></p> <p>”&CG50&”</p>”

Hi Saqib,

What is wrong with the above mentioned formula?

Thank you
0
 
Saqib Husain, SyedEngineerCommented:
You are using the



instead of

"

They are different.

Also wherever there is a " in the text it should be doubled  ""
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.