Click here to Skip to main content
15,883,705 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
Updated 26-Apr-15 5:26am
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
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