View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Petert[_2_] Petert[_2_] is offline
external usenet poster
 
Posts: 7
Default Seperate info in a cell

Hi,

In cell A1 I have the following information:

Fri 30 Oct 09:11

What I would like to do, via a macro I imagine, is to delete the month
and to seprate out the time into cell B1, so I would end up with:

Cell A1 - Fri 30

Cell B1 - 09:11

Any suggestions as to how I should achieve this would be much
appreciated

--
Cheers

Peter

(Reply to address is a spam trap - pse reply to the group)