Limit character count in cell from left

  • Thread starter Thread starter BMF
  • Start date Start date
B

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
 
hi BMF,

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

hth
regards from Brazil
Marcelo

"BMF" escreveu:
 
BMF said:
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
Click to expand...

=LEFT(A1,8) or =INT(A1/10000)
 
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
 
Back
Top