Importing text from clipboard into a sheet

  • Thread starter Thread starter GorKo
  • Start date Start date
G

GorKo

Is it possible to import text on a clipboard into a spreadsheet
without saving it first as a text file?
Or maybe there is an easy way to handle it by Excel?

Please advice.
 
Press Ctrl-v to paste whatever is on the clipboard into Excel.

--
Jim
| Is it possible to import text on a clipboard into a spreadsheet
| without saving it first as a text file?
| Or maybe there is an easy way to handle it by Excel?
|
| Please advice.
 
It will paste to the active cell so you have control by selecting the
correct cell first.

--
Jim
| > ActiveSheet.Paste
| >
| > "Jim Rech" wrote:
| > > Press Ctrl-v to paste whatever is on the clipboard into Excel.
| >
| > > --
| > > Jim
| > > "GorKo said:
news:f294997b-c073-4681-87d2-f25b79fb6d51@j22g2000hsf.googlegroups.com...
Click to expand...
| > > | Is it possible to import text on a clipboard into a spreadsheet
| > > | without saving it first as a text file?
| > > | Or maybe there is an easy way to handle it by Excel?
| > > |
| > > | Please advice.
|
| Actually I ment importing not pasting so I have a control to which
| cells it goes
 
It will paste to the active cell so you have control by selecting the
correct cell first.

--

| > ActiveSheet.Paste
| >
| > "Jim Rech" wrote:
| > > Press Ctrl-v to paste whatever is on the clipboard into Excel.
| >
| > > --
| > > Jim

| > > | Is it possible to import text on a clipboard into a spreadsheet
| > > | without saving it first as a text file?
| > > | Or maybe there is an easy way to handle it by Excel?
| > > |
| > > | Please advice.
|
| Actually I ment importing not pasting so I have a control to which
| cells it goes
Click to expand...

Thanks Jim for trying to help me but I do not think I have explained
clearly enough what I need. The text file that I need to convert to
excel is like a .CSV file and I need to apply a process like importing
a delimited file where I define columns of the text to be placed in
separate columns of the spreadsheet.

Thanks,

GorKo
 
Start recording a macro
Select the receiving cell
Data|Import external data|Import data (look for Text file in the "Files of type"
dialog)
(and this is the xl2003 menu system)

Stop recording the macro when you've finished the import.
 
Back
Top