View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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!