Pasting delimited text from clipboard directly into Excel Spreadsh
 

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/comm...excel.newusers

Pasting delimited text from clipboard directly into Excel Spreadsh
 

Have you tried: Data Text to Columns ?

BTW this newsgroup is not staffed by Microsoft, only hosted by them
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Anexceluser" wrote in message
...
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/comm...excel.newusers

Pasting delimited text from clipboard directly into Excel Spre
 

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.


--
East Coast, USA


"Bernard Liengme" wrote:

Have you tried: Data Text to Columns ?

BTW this newsgroup is not staffed by Microsoft, only hosted by them
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Anexceluser" wrote in message
...
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/comm...excel.newusers