Limit character count in cell from left

[BMF]

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 th
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

 

[Guest]

hi BMF,

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

hth
regards from Brazil
Marcelo

"BMF" escreveu:

 

[David Biddulph]

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)

 

[Guest]

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

 

[tony h]

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

 

[BMF]

It worked perfectly. Thanks a lot.