Macro to add text in Cell

[herve]

Hello,
In an Excel File, Sheet1, I have a text in Cell C11 to C200.
Does Anyone know a macro to Add "tititi" at the biginning of the text in these cells (C11 to C200)
Ex: In Cell C11 I have "QWERTY" and I want "tititiQWERTY"
In Cell C12 I have "AZERTY" and I want "tititiAZERTY"
Regards
H.

[Tom Ogilvy]

Sub AddPrefix()
Dim cell as Range
for each cell in range("C11:C200")
cell.value = "tititi" & cell.value
Next
End Sub

--
Regards,
Tom Ogilvy

"herve" <herve.1whbyg_1128600309.9941@excelforum-nospam.com> wrote in
message news:herve.1whbyg_1128600309.9941@excelforum-nospam.com...
>
> Hello,
> In an Excel File, Sheet1, I have a text in Cell C11 to C200.
> Does Anyone know a macro to Add "tititi" at the biginning of the text
> in these cells (C11 to C200)
> Ex: In Cell C11 I have "QWERTY" and I want "tititiQWERTY"
> In Cell C12 I have "AZERTY" and I want "tititiAZERTY"
> Regards
> H.
>
>
> --
> herve
> ------------------------------------------------------------------------
> herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
> View this thread: http://www.excelforum.com/showthread...hreadid=473726
>