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! |
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! |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com