divide the data in separate columns

[dashing_peep08]

Hi excel gurus,

Please help me on this query. I have data (dates and time) in Column A,
31 Aug 10 @ 1:50AM
3 Aug 09 @ 11:31PM
I wanted this to be copied to next columns such that the month day and year will be on three different columns. I dont need anything after the Year.
Example : 3 Aug 09 @ 11:31PM should be 3 in day column, Aug in Month column and 09 in the year column. automatically thats for 2009 or 11 for 2011. I tried the text column to column but im sure there is a simple formula which is more organized way to do this. by the way, the format of the text is in GENERAL.

Thanks in advance for your kind help.

 

[CWatts]

Like this?

Edit: had to switch formulas around as my brain defaulted to the US date format.

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:125px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >3 Aug 10 @ 1:50AM</td><td style="text-align:right; ">3</td><td >Aug</td><td style="text-align:right; ">2010</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=DAY(DATEVALUE<span style=' color:008000; '>(LEFT<span style=' color:#0000ff; '>(A1,FIND<span style=' color:#ff0000; '>("@",A1,1)</span>-1)</span>)</span>)</td></tr><tr><td >C1</td><td >=CHOOSE(MONTH<span style=' color:008000; '>(DATEVALUE<span style=' color:#0000ff; '>(LEFT<span style=' color:#ff0000; '>(A1,FIND<span style=' color:#804000; '>("@",A1,1)</span>-1)</span>)</span>)</span>,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")</td></tr><tr><td >D1</td><td >=YEAR(DATEVALUE<span style=' color:008000; '>(LEFT<span style=' color:#0000ff; '>(A1,FIND<span style=' color:#ff0000; '>("@",A1,1)</span>-1)</span>)</span>)</td></tr></table></td></tr></table>

 

[anandvarma]

try this

Excel Workbook
	A	B	C	D
1	data	year	month	day
2	27/07/2011 09:27	2011	7	27
3	27/07/2011 09:27	2011	Jul	27
Sheet1

 

[dashing_peep08]

Great CWAtts.. thanks. fantastic... thanks so much. Anand, ur formula will also be helpful on my next project for sure. thanks both...