You say you want a "macro", but the description of what you are looking for
is not a macro (another name for subroutine without arguments), so I'm not
totally sure how to answer your question. Here is code that will produce the
result you want in a variable named CC (we can dress it up as a function or
subroutine depending on what you might want, but you will have to clarify
that part for us)...

Dim AA As String, BB As String, CC As String
Dim Words() As String
AA = "They are capable"
BB = "think they"
Words = Split(AA)
Words(1) = Words(1) & " " & BB
CC = Join(Words)
MsgBox CC

--
Rick (MVP - Excel)


"jay dean" wrote in message
...

Hello !

AA is a variable that contains a string. BB is another string variable.

I need a macro that will create a new string CC which is made by
inserting BB into AA (after the first word in AA).

Example: If AA="They are capable" and BB="think they", then CC should be
"They think they are capable." Any help would be apreciated!

Thanks
Jay


*** Sent via Developersdex http://www.developersdex.com ***