Splitting a data in a cell into multile cell.
I hv a long sql cmd in one cell in excel. to copy paste in ISPF screen I want to split this cmd in 3 cells one down after other. I am attaching the JPG image. In that you can see a image of before splitting and after splitting...this I did manually. But since 1000 more data like this to be splitted ans doing it manually is very hectic. So looking for some formula after which I can get a data like a image of 'after split' in a next sheet.
I am also attaching a excel file for which I am looking for data split. Please experts help me in achieving this.
| Attachment | Size |
|---|---|
| dtt02.xls | 29 KB |


Recent comments
6 years 36 weeks ago
7 years 22 weeks ago
7 years 34 weeks ago
7 years 37 weeks ago
7 years 38 weeks ago
7 years 43 weeks ago
7 years 51 weeks ago
8 years 1 day ago
8 years 1 day ago
8 years 2 days ago