Is there a formula which can convert years and months in the same cell to years/months only?

Not applicable


I have to convert years and months in the same cell to years/ months only from a large data. Is this possible? Please help :((


Screenshot 2021-04-01 at 3.43.37 PM.png

2 Replies


With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases. 

For example, with your picture you cannot tell what format the cells in your sheet might have, or whether the text is subject to a formula. Whatever the case, a file without sensitive data always helps better.


Thank you for you all understanding and patience




I know I don't know anything (Socrates)


Do you mean "61 years 04 months" is to be converted to 61/04 and "63 years" to 63/0 ?