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

[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!

 

[Luke M]

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.

 

[alexrs2k]

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.