Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split cell content
Hello
I'm importing emails from Outlook and into Excel, that works pretty good. Except that the content of the email is pasted in one cell with this format. : A1 A2 Week=38 Day= Interest=2 Subject=2 coments=The teacher could have explained better the examples we got. Does anyone have an idea on how I can spilt the cell content so I get it split in different cells? A1 a2 a3 a4 etc Week=38 Day= Interest=2 Subject=2 Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
split cell content
Hi Ove
Try Text to columns under the Data menu -- Regards Ron de Bruin http://www.rondebruin.nl "Ove" wrote in message om... Hello I'm importing emails from Outlook and into Excel, that works pretty good. Except that the content of the email is pasted in one cell with this format. : A1 A2 Week=38 Day= Interest=2 Subject=2 coments=The teacher could have explained better the examples we got. Does anyone have an idea on how I can spilt the cell content so I get it split in different cells? A1 a2 a3 a4 etc Week=38 Day= Interest=2 Subject=2 Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split the content of cell | Excel Worksheet Functions | |||
Split cell content | Excel Discussion (Misc queries) | |||
How to split Cell content into two resulting cells | Excel Worksheet Functions | |||
Split cell values based on content | Excel Worksheet Functions | |||
split cell content | Excel Programming |