| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Text To Columns
Group, How do I convert 140 pieces of data that are comma delimited using VBA? The problem is Excel only converts text into 125 columns of data. How do I ensure the remainder of the data is placed on the spreadsheet. The data looks something like: Seek Button, 4, Power Button 8, Hi Band Level, 5.04, Low Band Level 2.32... Seek Button, 4, Power Button 8, Hi Band Level, 5.36, Low Band Level 3.24... Seek Button, 4, Power Button 8, Hi Band Level, 5.01, Low Band Level 2.76... Seek Button, 4, Power Button 8, Hi Band Level, 5.45, Low Band Level 2.36... Seek Button, 4, Power Button 8, Hi Band Level, 5.64, Low Band Level 2.47... Seek Button, 4, Power Button 8, Hi Band Level, 5.94, Low Band Level 2.35... Ultimately I'd like to have something like this... Seek Button Power Button Hi Band Level Low Band Level 4 8 5.04 2.32 4 8 5.36 3.24 etc. Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=498134 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
![ajocius[_49_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
