Inserting something at the begining of evrey cell

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
 
D

Don Guillett

try this
Sub addtext()
For Each c In range("i4:i24")
If Len(c) > 0 Then c.Value = "add " & c
Next
End Sub
 
J

Javi

This is going to sound like I'm a totall newbie (which I am :eek: ) bu
where exactly do I write that..

TIA!
Jav
 
D

Don Guillett

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
[email protected]
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...
 
Top