0

Hi, I'm trying to learn VBA for a personal project I am working on for excel. Right now I have in cell A2 - "2 years 1 month" and in cell B2 "1 year 2 months."

I am trying to get it so it prints in C2, "3 years 3 months." By doing some form of addition. Help would be awesome!

2
Contributors
1
Reply
6
Views
3 Years
Discussion Span
Last Post by ddanbe
0

You could somehow "walk" through your 2 strings using the MID function.
If both are numbers concat to a new string to be placed in C2.
Here is some info about the MID and related functions.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.