ASP Forum parsing text of one excel cell into separate cells theycallmean | Posted 8:35am 15. April 2008 Server Time | Hi team..pls help me here. I have an excel sheet with cells having text as shown below: [India]Delhi is the capital of India.[USA]Washington is the capital of USA.[China]Beijing is the capital of China.[Singapore]Singapore is the capital of Singapore. This complete text is in one single cell. Similar text is in other cells. I want to segregate these contents into separate columns so that: [India]Delhi is the capital of India ->  goes into one column [USA]Washington is the capital of USA -> goes into another column.. and so on.... Please help me. Any solution (except manual) will be preferred...mainly a solution that uses asp.net xeroxed | Posted 10:44am 7. May 2008 Server Time | What language are you most comfortable in? I wouldn't necessarily use asp/vbs to solve this one. More like Perl or C#. Reply to Post parsing text of one excel cell into separate cells Back to Forum Page