Quote Originally Posted by Rick Rothstein View Post
You do not say what you want to do with the text to the left of the hyphen, only that you want to "read" it. Do you want to put the text in the next cell over? Do you want to assign it to a variable within your code? Do you want to read in all of the text in all of the cell in the column into an array? Do you want to modify the text within its own cell so that only the text to the left of the hyphen remains? Something else?
Sorry. I was trying to be as brief as possible. Here are some samples of what my data looks like:
Heartsaver CPR and First Aid Course April 13th, 2013 [example without hyphen]
BLS Certification 2013 - 8:00am - 11:00am, April 12th 2013
PALS Renewal Course -- 9:00am to 5:00pm - April 4th, 2013

In looking this up, I just realized that some of my data is NOT separated by a hyphen so I am now in a bit of a pickle. What I need to do is use the information that is NOT a date or a time. This information, for example "BLS Certification 2013', I will use in a vlookup that has prices for this item in a named range. I will then have the looked-up price appear several columns to the right of this information shown above. (I hope this makes sense.) (The range will have "BLS Certification 2013" in one column with pricing in the column beside it.)

Thanks for any help you can provide.