Solved

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

Posted on 2014-02-24
5
409 Views
Last Modified: 2014-03-04
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
0
Comment
Question by:ScooterMcGee75
  • 3
  • 2
5 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39883212
="<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
 

Author Comment

by:ScooterMcGee75
ID: 39883370
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
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39896773
I am sorry, do you still need a response?
0
 

Author Comment

by:ScooterMcGee75
ID: 39903769
=”<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
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39903828
You are using the



instead of

"

They are different.

Also wherever there is a " in the text it should be doubled  ""
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question