I'd use Data|Text to columns.
fixed width
Draw a line only before :22

Then chose to skip that field (do not import)



agenda9533 wrote:

i have data column with the following format- 04:01:59:22
which means hh:mm:ss:msms
I want to get rid of msec. They dont allow to import this csv to access db.
How to convert hh:mm:ss:msms to hh:mm:ss ????????????????????

THANK YOU!!

--

Dave Peterson