C
comish4lif
I have a bunch of data (from Emails) that I need to transfer from a
Fixed Width format into Excel.
This AM, I pasted in about 10 messages worth, each message on it's own
worksheet and then put together some sample metrics, etc on a summary
page. Happy that I prettty much had what I wanted, including Macros to
convert the data from Text-to-Columns, I started to paste in the rest
of the data.
However, this time around, Excel is automatically reformatting the data
as Delimited as soon as I paste it in. How do I override this and force
Excel to not perform the Text-to-Columns as it is pasted in?
There is no Paste Special option to cover this.
Fixed Width format into Excel.
This AM, I pasted in about 10 messages worth, each message on it's own
worksheet and then put together some sample metrics, etc on a summary
page. Happy that I prettty much had what I wanted, including Macros to
convert the data from Text-to-Columns, I started to paste in the rest
of the data.
However, this time around, Excel is automatically reformatting the data
as Delimited as soon as I paste it in. How do I override this and force
Excel to not perform the Text-to-Columns as it is pasted in?
There is no Paste Special option to cover this.
