Split a Cell?

I

inveni0

I have a column "A" with data like the following:

6/12/2006 9:30

I would like to split this into two other columns like:

COLUMN B | COLUMN C
6/12/2006 | 9:30


Is there a formula that can split the cell data at the "SPACE" betwee
the date and time
 
B

Biff

6/12/2006 9:30

If the entry is a real Excel DATE/TIME there is no space!

There would only be a space if the entry was TEXT.

Biff
 
G

Guest

Inveni0,

I do it this way (clumsy maybe):

In column B, I enter either rounddown(A1,0) or int(A1)

In column C, I enter B1-A1

I then copy the formulas to values, delete column A, and then format column
B to show date and column C to show time.

Hope this helps.
 
B

Biff

Well, technically, T to C will parse the data if it is a DATE/TIME but look
at how it ends up!

Biff
 
R

Ragdyer

There's really *no* need for *any* formulas - *except* for the one to copy
the data to the adjoining column:

If A1 contains "6/12/2006 9:30" (no quotes)
Then in B1 enter
=A1

And the rest is accomplished with simple formatting!

A1 = m/d/yyyy
And
B1 = h:mm

And you're done!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top