View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Can any body help me out?

Put it in a cell, then do Data=Text to Column

Turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy

"kvenku " wrote in message
...
In My VBA coding i used to get long string with comma seperated. Is
there any API to read that string and parse into the excel sheet.

I am using excel 2000

Thanks
Venkatesh.


---
Message posted from http://www.ExcelForum.com/