Copy pasting info into a table, any way i can do this?

Jmart285

New member
Apr 1, 2010
30
1
0
seychellegabrielfan.com
I have a html table like this with few columns and several rows like the one below. I want to be able to copy a list of numbers or input data and paste it into one of the columns in one move.

Code:
<table border="1">
<tr>
<td>"column 1 with random txt"</td>
<td>column 2 with random txt</td>
</tr>
<tr>
<td>"column 1 with random txt"</td>
<td>column 2 with random txt</td>
</tr>
<tr>
<td>"column 1 with random txt"</td>
<td>column 2 with random txt</td>
</tr>
<tr>
<td>"column 1 with random txt"</td>
<td>column 2 with random txt</td>
</tr>
</table>
So if i have a list like:
A
B
C
D

How can I copy that entire list of and paste it in the table? the only way i know how to is by copying each letter one by one and putting it into the table so it looks like this


Code:
<table border="1">
<tr>
<td>a</td>
<td>column 2 with random txt</td>
</tr>
<tr>
<td>b</td>
<td>column 2 with random txt</td>
</tr>
<tr>
<td>c</td>
<td>column 2 with random txt</td>
</tr>
<tr>
<td>"d</td>
<td>column 2 with random txt</td>
</tr>
</table>
 


Divide it into multple parts before the input and after and then paste each part in to its own column in excel. Then just multiply it and paste each data column in.

here's what I mean:
TqKln.jpg
 
oh and btw, I could prob do it in open office if I knew the exact text, or better yet maybe I can make a ubot to do it, that would be a fun little project
 
for some reason openoffice on my mac doesnt work as well as the real excel which i have installed on my desktop pc. try the original excel if openoffice version doesnt work. You can try comma separating it and saving it as a .csv file then opening it in excel, might work
 
for some reason openoffice on my mac doesnt work as well as the real excel which i have installed on my desktop pc. try the original excel if openoffice version doesnt work. You can try comma separating it and saving it as a .csv file then opening it in excel, might work

Thats why I use Microsoft Excel on my mac...