ScooterMcGee75
asked on
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
<ul> <li><span id="product_description"> Cell J5</span><span id="product_description"><
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am sorry, do you still need a response?
ASKER
=”<p><span style="text-decoration: underline;"><strong>Fits Models</strong></span></p> <p>”&CC50&”</p> <p><span style="text-decoration: underline;"><strong>Descri ption</str ong></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>Specif ication</s trong></sp an></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>Additi onal Information:</strong></spa n></p> <p>”&CG50&”</p>”
Hi Saqib,
What is wrong with the above mentioned formula?
Thank you
Hi Saqib,
What is wrong with the above mentioned formula?
Thank you
You are using the
”
instead of
"
They are different.
Also wherever there is a " in the text it should be doubled ""
”
instead of
"
They are different.
Also wherever there is a " in the text it should be doubled ""
ASKER
In CB2, which looks like this:
<p><strong>Fits Models</strong></p> <p>CC2</p> <p><strong>Description</st
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?