Split cells

M

moglione1

Hi,

I have the following data "Sep 8 2005 12:00:00:000AM" and need i
splitting down so that only the sep 8 2005 is in the cell. Formattin
the cell will not work (unless I am doing something wrong).

Please help - thank you in advanc
 
S

swatsp0p

Is your entry a 'text' entry or a numeric entry with special formatting
to display MDY HH:MM:SS:nnn AM/PM?

more info, please
 
S

swatsp0p

If you are not sure if it is text or numeric, format the cell as
General. What is displayed?

If it is 38603, you have a date value in the cell and is probably
formatted as Custom: mmm d yyyy h:mm:ss:ss AM/PM

If is still shows Sep 8 2005 12:00:00:000AM you have a text entry. (are
there really 3 zeros just before the AM?)

What do you find?
 
S

swatsp0p

I would use Text to Columns for this. Highlight the cell, clic
Data>Text to Columns...

In Step 1 of the wizard, choose "Fixed Width", click Next

Step 2 dble click the arrows after the 'p' and the '8' to delete
click Next

Step 3 highlight the area to the right of '2005' and in the Colum
Data Format box, click 'Do not import column (skip)'. Set th
Destination to the desired location (can be same cell if desired).
click Finish.

Good Luc
 
S

saziz

moglione1 said:
The data appears to be a text entry (General in format cells).
Click to expand...


Try this:

=--LEFT(D7,6)
then format the cell as desired.
oops "D7" could be your cell of choice where you want to put it.

Syed
 
Top