add alpha letter to column of numbers
Thanks!!
"T. Valko" wrote:
Here's a simple macro:
Sub AddW()
Dim cell As Range
For Each cell In Selection
If cell.Value < "" Then
cell.Value = "W" & cell.Value
Else: cell.Value = cell.Value
End If
Next cell
End Sub
Select the range of part numbers then run the macro.
Biff
"-John W." <-John wrote in message
...
I have a column of part numbers that I want to re-identify with a "W" in
front of the number. There has to be a quick way of doing this but
everything I have tried fails.
Any advice??
|