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?
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.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
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)
Bookmarks