This may have already been answered, but I'm going to ask it anyway : )

I work with the same spread sheet every day and I need to limit the
character count in one of the date cells. The text come in as:

200607120910
and I need it to take off the hour and minute of the time stamp:
20060712

Thanks in advance.


--
BMF
------------------------------------------------------------------------
BMF's Profile: http://www.excelforum.com/member.php...o&userid=36297
View this thread: http://www.excelforum.com/showthread...hreadid=560750

hi BMF,

in an auxiliar column use =left(a1,8)

hth
regards from Brazil
Marcelo

"BMF" escreveu:


This may have already been answered, but I'm going to ask it anyway : )

I work with the same spread sheet every day and I need to limit the
character count in one of the date cells. The text come in as:

200607120910
and I need it to take off the hour and minute of the time stamp:
20060712

Thanks in advance.


--
BMF
------------------------------------------------------------------------
BMF's Profile: http://www.excelforum.com/member.php...o&userid=36297
View this thread: http://www.excelforum.com/showthread...hreadid=560750

"BMF" wrote in message
...

This may have already been answered, but I'm going to ask it anyway : )

I work with the same spread sheet every day and I need to limit the
character count in one of the date cells. The text come in as:

200607120910
and I need it to take off the hour and minute of the time stamp:
20060712

=LEFT(A1,8) or =INT(A1/10000)
--
David Biddulph

To do it without using another column, just highlight the column, then do
Data TextToColumns FixedWidth Next and set the column break line
where you want it Next click on the top of the column with the unwanted
characters and then check the button DoNotImportColumn(Skip) Finish

hth
Vaya con Dios,
Chuck, CABGx3



"BMF" wrote:


This may have already been answered, but I'm going to ask it anyway : )

I work with the same spread sheet every day and I need to limit the
character count in one of the date cells. The text come in as:

200607120910
and I need it to take off the hour and minute of the time stamp:
20060712

Thanks in advance.


--
BMF
------------------------------------------------------------------------
BMF's Profile: http://www.excelforum.com/member.php...o&userid=36297
View this thread: http://www.excelforum.com/showthread...hreadid=560750

the functions left mid right and len should allow you to do what you
want


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=560750

It worked perfectly. Thanks a lot.


--
BMF
------------------------------------------------------------------------
BMF's Profile: http://www.excelforum.com/member.php...o&userid=36297
View this thread: http://www.excelforum.com/showthread...hreadid=560750