Forum Discussion
Abdellatif1995
May 18, 2022Copper Contributor
Convert text to date
Hi All,
I need help with this issue please ,
I have this column with ages written in format like for example ( 2 years , 1 year , 13 month , 8 weeks )
I want to convert all these data to reflect the Number of Months only for it to become something like (24 ,12,13,2 ) . you can find attached the column I'm trying to convert.
Thanks All.
5 Replies
- SergeiBaklanDiamond Contributor
Practically the same with Beta functions
=LOOKUP(LEFT( TEXTAFTER( texts, " ") ), {"m","w","y"}, {1,0.25,12} )*TEXTBEFORE( texts, " ") - OliverScheurichGold Contributor
An alternative could be a macro. In the attached file you can click the button in cell E2 to start the macro.