Hello Excel Forum!
I could use some help on an easy one. My goal is to identify all cells within a column that have values, then add the string "E-" to the beginning of each cell.
I know how to identify the the cells with values within my range and I know that I need to use & to concatenate my string with each cell.
I am not sure how to identify each value within the loop and then how to actually execute the concatenate.
Here is my first attempt:
Public Sub Concatenate Test
Dim invoiceNameRng As Range
Dim invoiceNameValue As Variant
invoiceNameRng = ThisWorkbook.Worksheets("Sheet 1").Range("B2", Range("B2").End(xlDown))
For Each invoiceNameValue In invoiceNameRng
invoiceNameValue.Value = "E-" & invoiceNameValue
Next
Any help would be greatly appreciated!
-tvxl
Bookmarks