Sorry i having difficulty explaining what i want to do. I am trying to do a mileage log at my company. We have standard values for trip distances etc. We enter them in such as "Bldg A - Bldg B," "Bldg b - Bldg C" etc. I would like to somehow assign numerical values to those text strings, so that when several trips are in the same row, it will add them up and display total miles at the end of each row. Any ideas? Thank you.