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!
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.