Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a transpose please
Hello everyone. I have an Excel2000 spreadsheet with imported data in the range A1:A1000. Each cell, eg: A1, A2, A3 etc.... has a separate record, the record i a string, separated by the "/" delimiter. What I want to be able to do is look at each part of the record, but text to columns doesnt work as there are over 255+ columns and exce only works to circa 256. Ideally, what I would like is to transpose the record so that A1 wil be filled in column A1:A500 (or however long it takes to text t columns the record so that the text delimiter separates the records o transpose). Sorry if this isnt explained well, and many thanks for your help. Let me know if sending you an example of the record would help. Thank you again. Scott -- scottwilson ----------------------------------------------------------------------- scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112 View this thread: http://www.excelforum.com/showthread.php?threadid=27237 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with a transpose please
Dim vArr as Variant
Dim rw as Long rw = 1 vArr = Application.Split(Worksheets("sheet1").cells(rw,1) .Value,"/") worksheets("Sheet2").Range("A1:A500").Value = Application.Transpose(varr) -- Regards, Tom Ogilvy "scottwilsonx" wrote in message ... Hello everyone. I have an Excel2000 spreadsheet with imported data in the range: A1:A1000. Each cell, eg: A1, A2, A3 etc.... has a separate record, the record is a string, separated by the "/" delimiter. What I want to be able to do is look at each part of the record, but a text to columns doesnt work as there are over 255+ columns and excel only works to circa 256. Ideally, what I would like is to transpose the record so that A1 will be filled in column A1:A500 (or however long it takes to text to columns the record so that the text delimiter separates the records on transpose). Sorry if this isnt explained well, and many thanks for your help. Let me know if sending you an example of the record would help. Thank you again. Scott. -- scottwilsonx ------------------------------------------------------------------------ scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128 View this thread: http://www.excelforum.com/showthread...hreadid=272376 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need transpose? help.... | Excel Worksheet Functions | |||
Transpose from last to first | Excel Discussion (Misc queries) | |||
Want to Transpose | Excel Discussion (Misc queries) | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Please Help with TRANSPOSE | Excel Worksheet Functions |