Parsing the leading single quote

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
 
H

Harlan Grove

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating the change in lead times from a table. 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Search Text and Add a Blank Line 2
VBA word change keys 0
Delivery lead time formulas 1
Parse cell contents to new columns 6
Parse a Cell value using another listing showing criteria 6
how do I paste or import without parsing?? 3

Top