?
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
Medium Priority
?
414 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 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

Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

752 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