View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rowan Drummond
 
Posts: n/a
Default How do I merge new text into existing text cells.

Say your text is in column A and columns C and D are empty.
In C1 enter ".JPG" without the quotes.
In D1 enter =A1&$C$1
Copy this down as far as needed. You can then select Column D and paste
special values over column A before deleting Columns C and D.

Alternately you could use a macro. Select all the cells you want to
change and the run this:

Sub addjpg()
Dim cell As Range
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = cell.Value & ".JPG"
End If
Next cell
End Sub

Save your work before trying either option.

Hope this helps
Rowan

bweiner wrote:
I need to add the same text (.JPG) to existing text. I have over 4000
existing cells to add this same file extension to. I can't seem to figure
out how to do this without manually going into each cell.

Any suggestions would be great.