Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
I have four columns of data which I need to grab data from and have them entered into specific parts of html which is in a fifth column. Is this at all possible? You can see my spreadsheet he http://www.savefile.com/files/2459107 Listed below is the html from the field I need the data entered in: <font size=""2"" color=""#000066"" face=""comic sans ms"" <ul <li type=disc These charms are part of the Rembrandt Charm Collection. <li type=disc All Rembrandt Charms are available in Sterling Silver, Gold Plate, 10K Yellow Gold, 14K Yellow Gold or 14K White Gold. <li type=disc Please choose type of metal when ordering. Cost will be calculated at chheckout. <li type=disc Price shown is for sterling silver charm. <li type=disc Gold Plate Charms cost $ <li type=disc 10K Gold Charms cost $ <li type=disc 14K Yellow Gold Charms cost $ <li type=disc 14K White Gold Charms cost $ <li type=disc This charm measures "" high. <li type=disc Measurements are approximate. <li type=disc All Rembrandt Charms come with Lifetime warranty. </ul" For example cell I2 has the value I need to be placed after "<li type=disc Gold Plate Charms cost $" and so on. I need to do this for 6,000 entries, is it possible to automate this? -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#2
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
I'm really hoping this is possible, people keep viewing but not saying anything at all. Is it not possible? -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#3
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
It would take me a bit to figure out how to accomplish what you need most
efficiently. I imagine others feel the same way. The easiest way is to provide a before and after. My first thought is that I would probably try to do this using mail merge with Word. ************ Anne Troy www.OfficeArticles.com "evolart" wrote in message ... I'm really hoping this is possible, people keep viewing but not saying anything at all. Is it not possible? -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#4
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
Have you looked at the CONCATENATE function. Adding a space between each
cell----- =CONCATENATE(A1," ",B1," ",C1," ",D1) That way you don't even have to have adjacent cells. "Anne Troy" wrote in message ... It would take me a bit to figure out how to accomplish what you need most efficiently. I imagine others feel the same way. The easiest way is to provide a before and after. My first thought is that I would probably try to do this using mail merge with Word. ************ Anne Troy www.OfficeArticles.com "evolart" wrote in message ... I'm really hoping this is possible, people keep viewing but not saying anything at all. Is it not possible? -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#5
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
The problem is they data from those other cells have to be put into a certain spot within the text of the first cell. Here is the formula that I've come up with but it is too long for excel to use: ="<font size=""2"" color=""#000066"" face=""comic sans ms"" <ul <li type=disc These charms are part of the Rembrandt Charm Collection. <li type=disc All Rembrandt Charms are available in Sterling Silver, Gold Plate, 10K Yellow Gold, 14K Yellow Gold or 14K White Gold. <li type=disc Please choose type of metal when ordering. Cost will be calculated at chheckout. <li type=disc Price shown is for sterling silver charm. <li type=disc Gold Plate Charms cost $"&I20&" <li type=disc 10K Gold Charms cost $"&J20&" <li type=disc 14K Yellow Gold Charms cost $"&K20&" <li type=disc 14K White Gold Charms cost $"&L20&" <li type=disc This charm measures " high. <li type=disc Measurements are approximate. <li type=disc All Rembrandt Charms come with Lifetime warranty. </ul" I'm using excel 2003 btw. -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#6
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
Paul Wrote: Have you looked at the CONCATENATE function. Adding a space between each cell----- =CONCATENATE(A1," ",B1," ",C1," ",D1) That way you don't even have to have adjacent cells. Maybe I could use the method i was trying and then combine like 4 cells into one using concatenate. I will have to try that....lots of work though. It might be just as time consuming as doing it manually if I have to break up the html into like 5 cells and then conctenate all of them together. Will concatenate give me the formulas or just the results? If it passes the formulas that wont work. -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#7
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
Concatenate will string together the formula results, but it won't format
them for you. ************ Anne Troy www.OfficeArticles.com "evolart" wrote in message ... Paul Wrote: Have you looked at the CONCATENATE function. Adding a space between each cell----- =CONCATENATE(A1," ",B1," ",C1," ",D1) That way you don't even have to have adjacent cells. Maybe I could use the method i was trying and then combine like 4 cells into one using concatenate. I will have to try that....lots of work though. It might be just as time consuming as doing it manually if I have to break up the html into like 5 cells and then conctenate all of them together. Will concatenate give me the formulas or just the results? If it passes the formulas that wont work. -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#8
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
I'm gonna try a couple things and post back. I hope someone has another idea if what I'm trying doesn't work :) -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
#9
|
|||
|
|||
Trying to copy text from 4 columns into 1 column with HTML?
I figured it out! Very complex and had to be broken up into 5 cells and then all conctenated together and then the cell had to be copied and pasted-special value only. Way better then typing it all in manually though. I will explain in more detail and give an example spreadsheet in case anyone ever has a similar problem! Thanks everyone! -- evolart ------------------------------------------------------------------------ evolart's Profile: http://www.excelforum.com/member.php...o&userid=28129 View this thread: http://www.excelforum.com/showthread...hreadid=476514 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Splitting text in one column into two (or more) columns. | Excel Worksheet Functions |