ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   split cell content (https://www.excelbanter.com/excel-programming/310712-split-cell-content.html)

Ove[_2_]

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!

Ron de Bruin

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