How do I add custom prefix text to all cells within a column?

[Fucius]

Hi Guys,

How do I add custom prefix text to all cells within a column?

example:

Before:

one
two
three

After:

misc.one
misc.two
misc.three

Any help would be greatly appreciated!

Thanks

 

[Mr_Roscoe]

if your data is in cells B1, B2 & B2 then use the formula in cell A1

="misc."&B1

and copy down

HTH, Mr R.

 

[Biz]

Try using vba code below

Sub Macro1()
Dim LastRow As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row
With Range("B2:B" & LastRow)
    .Formula = "=""misc.""&A2"
    .Value = .Value
End With
    
End Sub

 

[Fucius]

**** you guys are quick! I figured it out and was about to delete this post but ya'll beat me to it. Thanks so much for the help!

 

[Biz]

**** you guys are quick! I figured it out and was about to delete this post but ya'll beat me to it. Thanks so much for the help!

Thanks for feedback.

Biz