Split the cell in Excel

[vasuv]

Hi ,

I have a excel sheet.in that one column called hardcoded.
we have sheet as folllows.
Name EMp_ID Hardcoded
----------------------------
ABC 1987870 1. EMP_SAL_CD : "2000","1300","Avg100"
2. DEPT_CD : "Manager","clerk","anlyst"
3. DNAME : "SALES","HR"
STU 1909890 1.EMP_SAL_CD : "6000","300","A100"
2. DEPT_CD : "Manr","cle","ant"
3. DNAME : "SALES","HR","STUD"
---
---

Now I want the O/P as follws

Name EMp_ID EMP_SAL_CD DEPT_CD DNAME
---------------------------------------------------------------------------------
ABC 1987870 "2000","1300","Avg100" "Manager","clerk","anlyst" "SALES","HR"
STU 1909890 "6000","300","A100" "Manr","cle","ant" "SALES","HR","STUD"
----
---
---
Can any one please help me out to write a shell script for this issue.

Thanks,
Vasu

[xml_looser]

take a picture of Excel
I think a vba problem

[DenisOxon]

Hi ,

I have a excel sheet.in that one column called hardcoded.
we have sheet as folllows.
Name EMp_ID Hardcoded
----------------------------
ABC 1987870 1. EMP_SAL_CD : "2000","1300","Avg100"
2. DEPT_CD : "Manager","clerk","anlyst"
3. DNAME : "SALES","HR"
STU 1909890 1.EMP_SAL_CD : "6000","300","A100"
2. DEPT_CD : "Manr","cle","ant"
3. DNAME : "SALES","HR","STUD"
---
---

Now I want the O/P as follws

Name EMp_ID EMP_SAL_CD DEPT_CD DNAME
---------------------------------------------------------------------------------
ABC 1987870 "2000","1300","Avg100" "Manager","clerk","anlyst" "SALES","HR"
STU 1909890 "6000","300","A100" "Manr","cle","ant" "SALES","HR","STUD"
----
---
---
Can any one please help me out to write a shell script for this issue.

Thanks,
Vasu

Hi,

Easiest way to to switch on Record New Macro. Then do to the first record what you want and you then have a script. If you only have a few records to go through then just run the script one record at a time, if many then add aloop to your script.

Denis

[thekashyap]

I would recommend Office VB script. Easy and powerful, takes a day or two to learn but has very wide application.