Macro to add text in Cell
 

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 tex
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

--
herv
-----------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...fo&userid=2731
View this thread: http://www.excelforum.com/showthread.php?threadid=47372

Macro to add text in Cell
 

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" wrote in
message ...

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