Thread: left & right
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default left & right

Hi,
I need copy a part of a field setted as date/hour.
then if I had in a field:

16/12/2008 20.50

I need take in new fields:

A1: 16 (like number)
A2: 20.50
A3: 50 (that's the minutes)
A4: 12 ( that's the month)

anyone got any idea about?
thanks 4 ur precious help.

--
BBB