Apr 01 2021 12:47 AM
Apr 01 2021 12:47 AM
Hi!
I have to convert years and months in the same cell to years/ months only from a large data. Is this possible? Please help :((
Apr 01 2021 01:45 AM
@Deleted
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
Nikolino
I know I don't know anything (Socrates)
Apr 01 2021 01:50 AM
@Deleted
Do you mean "61 years 04 months" is to be converted to 61/04 and "63 years" to 63/0 ?