Correction Last line should read Save as *.ods file Regards, MalJaros ----- Original Message ----- From: "maljaros" <malja...@icon.co.za> To: "Global Users@" <users@global.libreoffice.org> Sent: Thursday, 7 May, 2020 22:00:43 Subject: Fwd: [libreoffice-users] sum text column of common unit of measure numbers
Hi James >My cell phone provider only provides me a CSV with a text field for the >usage. >I want to =sum( it so I need it to be numbers. >Is a macro the easiest way to make a new column of common unit of >measure (GB?) numbers? > >15 KB >5 KB >10 KB >15 KB >5 KB >5 KB >5 KB >1.8 MB >5 KB >5 KB >15 KB >215 KB >130.2 MB >9.2 MB >475 KB >11.7 MB >10 MB >15 KB >12.1 MB >5 KB >10 KB >7.1 MB >5.3 MB >4.9 MB >15 KB >240 KB >130 MB >2.9 MB I suggest the following procedure. Open the *.TXT file in CALC, ticking "Separated by" and "Space" boxes. Should produce spreadsheet with Numeric values in Column A and Text (either MB or KB) in column B. In Cell C1 put =IF(B1="MB",A1*1000,A1) Copy Cell C1 down to bottom of table. Save as *.odt file Regards, MalJaros -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy