| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to give a string of data into different columns
Super expert,
If I have cell containing a series of data like this .... 1,12,9 1,2,9 1,22,17,18 23,23,1,9 24,21,1 1,23,11 22,1 2,3 Is it possible to use function or command to split them into columns? 1 12 9 1 2 9 1 22 17 18 23 23 1 9 24 21 1 1 23 11 22 1 2 3 I don't want to use "TEXT TO COLUMN" as some of the addresses can be overwritten. Thanks so much, Regards, Elton |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro or formula to compare columns and give a result of the odd o | Excel Discussion (Misc queries) | |||
| Match criteria in two columns and give a third colums result | Excel Discussion (Misc queries) | |||
| search a string as substring and give adjacent values | Excel Worksheet Functions | |||
| Right click on rows and columns does not give menu | Excel Discussion (Misc queries) | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
