Data Treatment | Column | GB and TB

[thelion]

Hello everyone,

First of all, I would like to mention that I'm not an expert with Excel. ?

So, I have a column with two different units (GB and TB):

Space PV

104.10 GB

1.7 TB

I will need this values to do some calculations, but I can't do nothing because I need to replace:

1. "." for ","
2. "GB" for " " -> remove GB text
3. "TB" for " " -> remove TB text AND multiply the value for 1024 (conversion TB to GB)

This action should be done from a Button.

Thank you so much.

 

[thelion]

The data result should be:

Space PV (GB)

104,10

1740.80

 

[thelion]

Can anyone help me please?

 

[Fluff]

Maybe
=LEFT(SUBSTITUTE(A2,".",","),FIND(" ",A2)-1)*IF(RIGHT(A2,2)="TB",1025,1)