Excel 2002 - Split date & time in a cell 1

[johncurtis]

Hi

I have a large spreadsheet where date and time are both within single cells (separated by two spaces), e.g.

17/07/2007 13:50:15

I'd like extract just the time out of this into a new column, but my excel skills are sadly lacking. Can anyone help please.

Thanks
John

I've got a stepladder. It's nice, but I wish I knew my real ladder.

 

[GlennUK]

Menu command Data/Text To Columns?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[johncurtis]

Great, thanks Glenn. Didn't know about that!

John

I've got a stepladder. It's nice, but I wish I knew my real ladder.

 

[SkipVought]

It always helps to understand.

faq68-5827

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]