How to remove characters from cells in excel vba

Hi,

I was wondering, in the D and F column, how can I use vba to remove the "Day" which is in front of the numbers.
I want to do this because I would like to compare these numbers but am unable to do so because they are not considered integers.
Also, all these data in the excel attachment are all randomly generated, but I just extracted this small portion out.

PS: New to excel vba

you don't need VBA, but simple text formulas

Hmm, how do I add these formulas to the whole column? Assuming I know them

To be honest, the fastest way to do this is with a traditional REPLACE, no functions nor vba.

Highlight the selection you want to remove data from, then press CTRL+H to bring up the REPLACE form. In the FIND WHAT box, enter Day (make sure to add a space after the word Day so that excel will clear that out to).

In the REPLACE WITH box, leave it blank.

Let me know if it helps

Hey, thanks it works! But when the columns D and F data changes, the "Day" comes back. Is there a way to permanently filter out the "Day" word?

Where is the data coming from? How often does it change?

It's coming from another spreadsheet in the same excel file. It changes only when I press a button

the best way is to remove day before It's coming