Macro to add text in Cell

  • Thread starter Thread starter herve
  • Start date Start date
H

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 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
 
Sub AddPrefix()
Dim cell as Range
for each cell in range("C11:C200")
cell.value = "tititi" & cell.value
Next
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Reference a cell in criteria range 2
Code to Implement Required Cells Not Working 3
Cell Manipulation 1
MACRO ACTIVATED AUTOMATICALLY 1
Use of Intersect: Place Value in one cell AND remove from another 2
Delete space in Text 4
Macro to add text in Cell (in a range of Row) 2

Back
Top