Re: $$Excel-Macros$$ Transpose Data from cell to columns

2011-09-14 Thread karan 1237
Thnx to all for this great help..! Kaяan

Re: $$Excel-Macros$$ Transpose Data from cell to columns

2011-09-13 Thread NOORAIN ANSARI
Dear karan, By Excel Use formula *=SUBSTITUTE(A1,CHAR(10),"-") * in second Column, and Copy and Paste it as value, then normal you can use Text to column . On Tue, Sep 13, 2011 at 5:02 PM, karan 1237 wrote: > Dear Noorain thanks for replying, but still my query has not solv

Re: $$Excel-Macros$$ Transpose Data from cell to columns

2011-09-13 Thread dguillett1
ther:=True, OtherChar:="" & Chr(10) Cells.EntireColumn.AutoFit Cells.EntireRow.AutoFit End Sub From: karan 1237 Sent: Tuesday, September 13, 2011 4:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Transpose Data from cell to columns Dear All, I'v to transpose data f

Re: $$Excel-Macros$$ Transpose Data from cell to columns

2011-09-13 Thread Prince Maurya
Select the data u want to transpose copy it...then right ckick to another location then select paste special from the list..check on transpose box & click ok. On Tue, Sep 13, 2011 at 2:35 PM, karan 1237 wrote: > Dear All, > > I'v to transpose data from a cell to columns. Please solve my quer

Re: $$Excel-Macros$$ Transpose Data from cell to columns

2011-09-13 Thread SridharBL
Copy the Texts from the Formula Bar. This will copy as individual data's, paste this on empty cells. Paste special Transpose. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

Re: $$Excel-Macros$$ Transpose Data from cell to columns

2011-09-13 Thread karan 1237
Dear Noorain thanks for replying, but still my query has not solved. I want to transpose data from cell to columns, I don't want to do Text to columns. Please see attached file. Kaяan

$$Excel-Macros$$ Transpose Data from cell to columns

2011-09-13 Thread karan 1237
Dear All, I'v to transpose data from a cell to columns. Please solve my query. Thnx in advance Kaяan