Copy and buid a variable with a Macro

Hi Guys,

i've try to found a solution to this problem but unsuccessful.

I need to create a Macro that copy a variable value and copu in a cell.
From this Cell, i need to delete some parts and create a new Variable.

This is:

Insert a Value like a text in A1, ex:

11 22 33 44 55 66 77 88

Now i need to delete the fourth and the eighth pair of text and copy the new value in a new cell (A2 for example).

So the final value will be "11 22 33 55 66 77".

"11 22 33 44 55 66 77 88" must be a variable, so i can have

22 22 33 44 55 55 66 77 -> 22 22 33 55 55 66

or

AA BB CC DD 11 22 33 44 -> AA BB CC 11 22 33

I've try to make a macro but when i change the variable, i get ever the first value !

Can you help me ?

Thanks !!

Thank you very much mate

Here is mine (not very impressive, but seems to work)

Sub macro()
Dim x
Dim res As String

x = Split(Range("A1").Value, " ")

x(3) = ""
x(7) = ""
res = Join(x, " ")
Range("A2").Value = res
End Sub