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
This should do it. Try it!! Sub breakitupSAS() Dim mc As Range Set mc = Range("a1") mc.TextToColumns Destination:=mc, DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _ Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _ Other:=True, OtherChar

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