Parsing the leading single quote

  • Thread starter Thread starter dtg86
  • Start date Start date
D

dtg86

Is there an easy way to parse the leading quote from a cell using VB fo
a macro? Time cells are imported in as text and I would like to conver
them back to time. Text to Columns works, but I would like to automat
that step. Thanx for any help
 
Is there an easy way to parse the leading quote from a cell using VB for
a macro? Time cells are imported in as text and I would like to convert
them back to time. Text to Columns works, but I would like to automate
that step. Thanx for any help.
Click to expand...

If all values in a single column, multiple row range start off as text but could
be easily converted into time values using Data > Text to Columns, then use Data
 
Back
Top