How to format a iCalender file by Excel?

Hello there

I need to import the iCalender file to Task under Outlook. before I import that I need to modify the format by Excel.

The original file looks like this.

I tried to use the build-in function Text-to-column, it doesn't work, also, I use a formula to added a comma ending with each line, and use Text to column again, still did not work.

I'm not good with Excel, but I guess If I can change the format like this, Outlook will happy to import it. Sounds like a group of each item ( BEGIN, SUMMARY...)

Any idea I can format it by easy way or import to outlook?

Thanks

excel

Formulas and Functions

Forum Discussion

How to format a iCalender file by Excel?

Resources