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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Meera" wrote:

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!

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.
--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"Meera" wrote:

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!