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
398 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now