Pasting delimited text from clipboard directly into Excel Spreadsh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Many a times I need to paste delimited text from other applications (UNIX
telnet sessions etc.) directly into an Excel Spreadsheet.
I select and copy the delimited text to the clipboard.
But when I try to paste or "paste special" in Excel, I do not see anyway I
can paste the delimited text into separate cells.
Instead, I end-up creating a delimited text file and then import the file
into a spreadsheet.
It would be great if Microsoft can provide a method to paste the delimited
text directly into a spreadsheet from the clipboard.
--
East Coast, USA

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...f3a6a3bc27&dg=microsoft.public.excel.newusers
 
Have you tried: Data > Text to Columns ?

BTW this newsgroup is not staffed by Microsoft, only hosted by them
best wishes
 
Thanks for the reply, Bernard.

That works better - but it involves two steps.
1. Pasting the text in a column and then
2. Data > Text to Columns

I was wondering if - (while pasting) I can tell Excel to use the delimiter
to place the text directly into columns.
 
Back
Top