Hi together,
had just the same problem: Data from the ISP was in KB MB GB mixed up all together, like this
25 KB
311 KB
3,66 MB
34 KB
9,32 MB
3,03 MB
1,23 MB
3,47 MB
300 KB
49 KB
3,47 MB
So before I can start here to count together, how much Bytes I daily spent on internet, I had to convert the whole row.
I thought this problem must be a common and maybe already solved one, and yes I found that:
https://www.mrexcel.com/board/threads/convert-mb-gb-kb-to-bytes.878293/
...good man: =LEFT(A1,FIND(" ",A1))*1024^MATCH(RIGHT(A1,2),{"KB","MB","GB"},0)
...for M$Excel... So for Libre not directly usable: as in my case (for whatever reason I ever decided to use a german version of libreoffice...) I also had to figure out the right german names for the functions, but now I managed it and want to share it with you :-) :
=LINKS(A11;FINDEN(" ";A11))*1024^VERGLEICH(RECHTSB(A11;2);{"KB";"MB";"GB"};0)
25 KB 25600
311 KB 318464
3,66 MB 3837788,16
34 KB 34816
9,32 MB 9772728,32
3,03 MB 3177185,28
1,23 MB 1289748,48
3,47 MB 3638558,72
300 KB 307200
49 KB 50176
3,47 MB 3638558,72
TATA! :-)
...it souldn't be too hard to convert this into english... I am so happy after hours of work!
The hardest point was, that the character between last number and first letter ("K","M","G") was not a space...
but I haven't figured out which character it was: with the RECHTSB ("RIGHTB"?) function I got the last two characters for the VERGLEICH (MATCH) so I didn't investigate any longer ;-)
Enjoy, because we care and share!
brgds
stefan
Austria, Vienna ...and no snow on christmas eve...
This is not a matter of the format set for the cells, but one of the recognition of text appended to the numeric part of the entries as a modifyier to the meaning.
There is no ready-made tool for the task.