How to format a iCalender file by Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-2607974%22%20slang%3D%22en-US%22%3EHow%20to%20format%20a%20iCalender%20file%20by%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2607974%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22votecell%20post-layout--left%22%3E%3CDIV%20class%3D%22js-voting-container%20d-flex%20jc-center%20fd-column%20ai-stretch%20gs4%20fc-black-200%22%3E%3CSPAN%3EHello%20there%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22js-voting-container%20d-flex%20jc-center%20fd-column%20ai-stretch%20gs4%20fc-black-200%22%3E%3CSPAN%3EI%20need%20to%20import%20the%20iCalender%20file%20to%20Task%20under%20Outlook.%20before%20I%20import%20that%20I%20need%20to%20modify%20the%20format%20by%20Excel.%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22postcell%20post-layout--right%22%3E%3CDIV%20class%3D%22s-prose%20js-post-body%22%3E%3CP%3EThe%20original%20file%20looks%26nbsp%3Blike%20this.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%228mX0E.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300327iA26A99A156399022%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%228mX0E.png%22%20alt%3D%228mX0E.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20the%20build-in%20function%20Text-to-column%2C%20it%20doesn't%20work%2C%20also%2C%20I%20use%20a%20formula%20to%20added%20a%20comma%20ending%20with%20each%20line%2C%20and%20use%20Text%20to%20column%20again%2C%20still%20did%20not%20work.%3C%2FP%3E%3CP%3EI'm%20not%20good%20with%20Excel%2C%20but%20I%20guess%20If%20I%20can%20change%20the%20format%20like%3CSPAN%3E%26nbsp%3Bthis%3C%2FSPAN%3E%2C%20Outlook%20will%20happy%20to%20import%20it.%20Sounds%20like%20a%20group%20of%20each%20item%20(%20BEGIN%2C%20SUMMARY...)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bhBe5.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300328i5B9681DB982D0DC9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22bhBe5.png%22%20alt%3D%22bhBe5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20I%20can%20format%20it%20by%20easy%20way%20or%20import%20to%20outlook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2607974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
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.

8mX0E.png

 

 

 

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...)

bhBe5.png

 

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

 

Thanks

0 Replies