Click here to Skip to main content
15,851,242 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I have the following data in excel file D:\attendance in E column in one cell in different rows

Pankaj sharma;#234;#khushal verma;#786;#parul datta;#456;#.....


I would like to convert it to this using VBscript:

pankaj sharma
khushal verma
Posted
Updated 26-Apr-15 6:26am
v3
Comments
Maciej Los 26-Apr-15 11:26am    
VBScript or VBA?
Member 11643246 26-Apr-15 12:42pm    
i need a Vbscript

 
Share this answer
 
See this: Split text into different cells[^], then record a macro ;)
 
Share this answer
 
Comments
Member 11643246 26-Apr-15 12:27pm    
i have a working vba but as new file arrives i have to use that macro in that i am in search of VBscript such that i will give only path of file in that script and it will give me the result in above format

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900