Inserting something at the begining of evrey cell

  • Thread starter Thread starter Javi
  • Start date Start date
J

Javi

How can I insert soemthing at the begining of evrey cell in a column?

i.e.

Product Name1
Product Name2
Product Name3
Product Name4
Product Name5

into

Something Product Name1
Something Product Name2
Something Product Name3
Something Product Name4
Something Product Name5

As always, TIA,
Jav
 
try this
Sub addtext()
For Each c In range("i4:i24")
If Len(c) > 0 Then c.Value = "add " & c
Next
End Sub
 
This is going to sound like I'm a totall newbie (which I am :o ) bu
where exactly do I write that..

TIA!
Jav
 
This is a macro. Easiest way, for you, is to right click on the sheet
tab>view code>copy/paste this>SAVE workbook.
the i4:i24 applies to the range of your column. If your data is in b2:b200,
change accordingly. To execute just click anywhere within the text of the
macro and touch the f5 key.

As always, you may want to try on data that doesn't matter or do not save
until satisfied it is what you want.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Don Guillett said:
try this
Sub addtext()
For Each c In range("i4:i24")
If Len(c) > 0 Then c.Value = "add " & c
Next
End Sub
Click to expand...
 
Back
Top