Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
?
415 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

618 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