G
geniusideas
In one cell i have many char seperated by comma example :
Cell A1 - C123,A244,A555,....And sometime more than 254 (total Column
in excel)
Cell A2 - C451,A123,.....
Cell A3 - B123,D245,...
Until >100 rows.
Now I am using text to column to seperated the char into individual
cell in column.
The problem now :
1) I have to arrange in rows not column..Pls help.
2) We only can arrange in column if qty < 254, if > How..
If we use macro what code to be use..
http://microsoft-excel-macro.blogspot.com
Cell A1 - C123,A244,A555,....And sometime more than 254 (total Column
in excel)
Cell A2 - C451,A123,.....
Cell A3 - B123,D245,...
Until >100 rows.
Now I am using text to column to seperated the char into individual
cell in column.
The problem now :
1) I have to arrange in rows not column..Pls help.
2) We only can arrange in column if qty < 254, if > How..
If we use macro what code to be use..
http://microsoft-excel-macro.blogspot.com