Chopping a cell value?

[Mirisage]

Hi Forum,
Could you help me on this.
I have the following variable called "File_Size" and its values are like below.

File_Size
616MB
1GB
616MB

Q: I wanted to get the numeric portion out and create a new variable called New_var.

Answer:
New_var
616
1
616

My attempt:
I used left function like below but I have to define several lengths depending on the number of numerics in each cell values which is not possible given I have several thousand datasets.

=left(text, 3)

Could someone help me?
Thanks
Mirisa

[dflak]

Well, since the last two characters will always be KB, MB, GB, TB you can use: =LEFT(A1,LEN(A1)-2).

[Mirisage]

Hello Dflak,
Your code works great!
Thank you so much.
Mirisa