Hello,
I have 19,000 cells of coulmn data in my notepad.I want to
copy this in a row format in excel.I cannot copy and paste and then
transpose it becuase excel accepts only 256 coulmns of data. Please
help!!!
Sri.
Hello,
I have 19,000 cells of coulmn data in my notepad.I want to
copy this in a row format in excel.I cannot copy and paste and then
transpose it becuase excel accepts only 256 coulmns of data. Please
help!!!
Sri.
break it up into blocks of 200 columns, and edit copy edit paste special transpose each one in turn. This will work if no column is more than 250 rows deep. If that is the case, you will need to make multiple sheets.
How many columns do you currently have?
Gord Dibben MS Excel MVP
On 18 Aug 2006 01:50:28 -0700, "balsrin" <[email protected]> wrote:
>Hello,
> I have 19,000 cells of coulmn data in my notepad.I want to
>copy this in a row format in excel.I cannot copy and paste and then
>transpose it becuase excel accepts only 256 coulmns of data. Please
>help!!!
>
>Sri.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks