C
Chewy509
I'm trying to modify a large excel document (60k+ rows), to change one
thing in each cell. You may say just use the find and replace, but
that changes the data in the cell. What I have got is the time each
Item took to do but what gets put in to the xls file (I can not change
this from the raw data) is eg.
"' 0:55:28 s"
I can remove the " s" using the find and replace but when I try to
remove the "'" it changes the data to "12:55:28 pm".
When I click on the cell manually and remove the "' " it dose not
change the data.
I tried to write a VBA macro but have had no luck (endless loops and
so on).
Thank you.
thing in each cell. You may say just use the find and replace, but
that changes the data in the cell. What I have got is the time each
Item took to do but what gets put in to the xls file (I can not change
this from the raw data) is eg.
"' 0:55:28 s"
I can remove the " s" using the find and replace but when I try to
remove the "'" it changes the data to "12:55:28 pm".
When I click on the cell manually and remove the "' " it dose not
change the data.
I tried to write a VBA macro but have had no luck (endless loops and
so on).
Thank you.