Pasting delimited text from clipboard directly into Excel Spreadsh

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
 
B

Bernard Liengme

Have you tried: Data > Text to Columns ?

BTW this newsgroup is not staffed by Microsoft, only hosted by them
best wishes
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top