How to move data from one variable to another

[metz]

Hi
I am a beginner in VBA.
Could anyone help me with this simple question.

I want to move a string from one variable to a specific position of another variable.
For example;
A = "abcedfgh"
B = "xyz"

I want to move B to the third byte of A, so the result value of A will become "abxyzfgh".
How can I do it in VBA?

Thanks in advance.

metz

[Paul_Hossler]

A = Left(A,2) & B & Right(A, Len(A)-2)

[p45cal]

A = Replace(A, Mid(A, 3, Len(B)), B,,1)

[metz]

A = Left(A,2) & B & Right(A, Len(A)-2)



Thanks Paul :yay

[metz]

Thanks guys :bow:

[snb]

Sub M_snb()
a = "abcedfgh"
b = "xyz"

sn = Split(StrConv(a, 64), Chr(0))
sn(2) = b & sn(2)
a = Join(sn, "")

MsgBox a
End Sub