Here is what I ended up using in VBA

Dim TheCell As Range

For C = 1 To 100
Set TheCell = Cells(C, 2)
If IsEmpty(TheCell.Value) Then
TheCell.Value = TheCell.Offset(0, -1).Value
End If
Next C
End Sub

use a second loop if you want to continue to add the text to addition
cells


JMB wrote:
One other thing, you could enter the first IF statement I suggested in a
third column, then copy this third column, click Edit/Paste Special/Values
over your original data in column B.

Just be sure to back up before trying anything new.


" wrote:

Not exactly (thanks for the try)... that puts a blank where some test
was that I want to keep.

It would be more like =IF(A1="yes","yes", DO NOTHING)

where do nothing means leave that cell alone!

Befo
A B
1 example text (blank)
2 BlahBla goodstuff
3 example text (blank)

After:
A B
1 example text example text
2 BlahBla goodstuff
3 example text example text