How can I add the same text, ex 'Fa-09' to every cell in a column

  • Thread starter Thread starter Meera
  • Start date Start date
M

Meera

I'm trying to add the text 'Fa-09' to every cell in a column that already has
existing text. I know 'merging' the cells together will simply take the
value from the first column and overwrite the other column. I tried
'consolidating' but that is more for numerical data...

Any help would be greatly appreciated. Thank you!
 
To add to beginning of text with a space:
="Fa-09 "&A1
To add to end of text with a space:
=A1&" Fa-09"

Copy down as needed. (Note that the ampersand is the quick form for
concatenate, and can be used to string multiple bits of cell contents,
numbers, and text.
 
Try this macro:

Sub RewriteCell()
Dim lngRow As Long
lngRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To lngRow
Range("A" & i).Value = "Fa-09 " & Range("A" & i).Value
Next
End Sub

change the column "A" to whatever column you need.
 
Back
Top