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#.
lcaputi | Posted 10:46am 18. November 2008 Server Time |
I've got a similar issue. I've got a spreadsheet that is simply a directory listing of every entry in a very large directory. One cell contains the path info. I'd like to parse out the 3rd, 4th, and 5th directory levels into separate cells, as well as the extension of the filename. So, for example, one cell reads "F:\DEPT\11730\0003\info\doc1.doc. I'd like to get 11730, 0003, info and .doc into 4 separate cells. Any help would be greatly appreciated.
Reply to Post parsing text of one excel cell into separate cells
|
|
|
