Thnx to all for this great help..!
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
https://plus.google.com/43524614789164919/posts
http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann
http://karanxel.blogspot.com/
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 karan1...@gmail.com wrote:
Dear All,
I'v to transpose data from a cell to columns.
:= 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 from a cell to columns. Please solve
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 karan1...@gmail.com wrote:
Dear Noorain thanks for replying, but still my