Use this array formula:
=LEFT(A1,MIN(IFERROR(FIND({"KB","MB","GB","TB"},A1),1E+99))-1)/INDEX({1048576,1024,1,0.0009765625},MATCH(RIGHT(A1,2),{"KB","MB","GB","TB"},0)) & "GB"
Being an ...READ MORE
Oct 31, 2022
in Others
by
narikkadan
• 63,600 points
•
2,424 views