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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago