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
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago