Title is self-explanatory, I'm doing some work for university and it bothers me to copy/paste over and over...
As a demonstration
*File 1*
[1]" "
[2]" "
[3]" "
...etc
*File 2*
asd
btv
onv
.... etc
I want to get this result
[1]"asd"
[2]"btv"
[3]"onv"
without manually copy/pasting invidivual selections onto fields
Thanks.
How can I copy/paste different selections onto different fields at once?
Re: How can I copy/paste different selections onto different fields at once?
What types of files are you using?
Feeling as though I've infringed your right to freedom of speech?
[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]
[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]
[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]
[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]
Re: How can I copy/paste different selections onto different fields at once?
It can be anything as long as I paste desired results onto Word/Notepad. (Any program that enables this feature, that is.)
Re: How can I copy/paste different selections onto different fields at once?
Ok, well I would use Excel to do it then, if I'm understanding you correctly.
I'll copy & paste the data of each file of yours onto a sheet of an excel document(File 1 onto sheet 1, and File 2 onto Sheet 2).
Once that is the case, then I'll create the following formula on an additional sheet, sheet 3, (assuming that each list of data starts in Cell A1, Column A, Row 1) :
=sheet1!A1&" "&sheet2!A1
[The " " in the above formula indicate a space between the two data strings. You can remove this if you'd like, as it all depends on what you want]
Once you have that, drag the formula down as far as you'd need to.
Then copy the new list that you formed on sheet 3 and paste it onto your word document/notepad.
It should do what you want, unless I misunderstood you.
I'll copy & paste the data of each file of yours onto a sheet of an excel document(File 1 onto sheet 1, and File 2 onto Sheet 2).
Once that is the case, then I'll create the following formula on an additional sheet, sheet 3, (assuming that each list of data starts in Cell A1, Column A, Row 1) :
=sheet1!A1&" "&sheet2!A1
[The " " in the above formula indicate a space between the two data strings. You can remove this if you'd like, as it all depends on what you want]
Once you have that, drag the formula down as far as you'd need to.
Then copy the new list that you formed on sheet 3 and paste it onto your word document/notepad.
It should do what you want, unless I misunderstood you.
Feeling as though I've infringed your right to freedom of speech?
[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]
[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]
[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]
[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]
Re: How can I copy/paste different selections onto different fields at once?
Thanks for the solution, however it didn't work for me, but as the demonstration here's what I precisely need, because I didn't demonstrate/explained it thoroughly as I should.
I'm getting "","","" asdbsdcsd result,but I need "asd","bsd","csd" like literally. (you can say this is an ordering in a way, assign selection 1 in between the first "", assign selection 2 in between the second " and so on.)
So you can say it's a mapping in a sense
Here is a picture (of course you'd have more than 1 element)
I'm getting "","","" asdbsdcsd result,but I need "asd","bsd","csd" like literally. (you can say this is an ordering in a way, assign selection 1 in between the first "", assign selection 2 in between the second " and so on.)
So you can say it's a mapping in a sense
Here is a picture (of course you'd have more than 1 element)
Re: How can I copy/paste different selections onto different fields at once?
I wrote a small java application that does EXACTLY what was descriped in your first post:
https://puu.sh/qht8l/cfb96ace13.class
Save as "Insert.class". Run from the command line with "java Insert file1.txt file2.txt".
If you don't have the java runtime: https://www.java.com/
Be aware: this is a very specific solution for this problem. Replacing " " in each line from file1 with "<string>" where <string> is a line from file2.
https://puu.sh/qht8l/cfb96ace13.class
Save as "Insert.class". Run from the command line with "java Insert file1.txt file2.txt".
If you don't have the java runtime: https://www.java.com/
Be aware: this is a very specific solution for this problem. Replacing " " in each line from file1 with "<string>" where <string> is a line from file2.
Re: How can I copy/paste different selections onto different fields at once?
Yeah, the only way you're going to get your desired result is by using macros / a different kind of program, as the above poster wrote for you.
Unfortunately I don't have enough experience in programming other than excel macros, but even then my knowledge is limited, and it will waste your time, waiting for me to do a macro for you.
I apologise I couldn't help any further Alivandesiz, but I hope that you manage to find the solution you're looking for asap.
Unfortunately I don't have enough experience in programming other than excel macros, but even then my knowledge is limited, and it will waste your time, waiting for me to do a macro for you.
I apologise I couldn't help any further Alivandesiz, but I hope that you manage to find the solution you're looking for asap.
Feeling as though I've infringed your right to freedom of speech?
[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]
[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]
[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]
[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]
Who is online
Users browsing this forum: No registered users and 17 guests