E
Eanna
Hello,
I'd really appreciate some help on the following.
I'm cutting columns of values delimited by spaces from a console
window.
I'd like to paste the values into excel and at the same time have Excel
place values from each column into separate cells, using the spaces to
delimit the columns.
Currently, the paste special only shows a paste as text options which
places a full row into a single cell.
Currently I can only achieve my result by:
pasting data into text file
opening text file in excel
engaging the conversion options at that stage
Thanks in advance,
E
I'd really appreciate some help on the following.
I'm cutting columns of values delimited by spaces from a console
window.
I'd like to paste the values into excel and at the same time have Excel
place values from each column into separate cells, using the spaces to
delimit the columns.
Currently, the paste special only shows a paste as text options which
places a full row into a single cell.
Currently I can only achieve my result by:
pasting data into text file
opening text file in excel
engaging the conversion options at that stage
Thanks in advance,
E