There are a lot of times where I would need to save data in a text file before I can use the "Get External Data: From Text".
How can I import my clipboard so the text import wizard can be used?
I found help from this thread
http://www.excelforum.com/excel-misc...-to-excel.html
what you want to copy something , leave it on the clipboard then get excel to get the data?
there is already that facility its called "paste"
copying to a text file then opening with excel is really tha only way to go.
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
paste the data into a cell, then click on the little paste icon that shows up right next to your pasted cell and select "Use import wizard"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks