Adding(Append) fix string before a particular cell

**prayami** · 01-02-2008, 05:19 PM

Hi,

I frequently require to add or append perticular string in some of the cells( note: cells are in sequence or together in the column ).
It will be really helpful if we can do that in excel.

e.g.

If in perticular column, some of the column cells values are :
ABC
EFG
HIJ
KLM
OPQ

I want to add perticular string e.g. "IBM" on the beginning of the cell value.
e.g.
IBM ABC
IBM EFG
IBM HIJ
IBM KLM
IBM OPQ

Right now I just copy and paste "IBM" in each cell.

Is it possible like formula to set in formula for one cell and then drag.

Thanks,

**VBA Noob** · 01-02-2008, 05:29 PM

Say the data in Column A enter this in B1 and drag down

="IBM "&A1

then select column B > copy > paste special values and delete column A

or you could use.

Press Alt + F11 > Insert new module > paste in the below and close VBA editor > select the range > then press Alt + F8 and select AddText and run

Sub AddText()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Selection
    If Not IsEmpty(c) Then
        c.Value = "IBM " & c.Value
    End If
Next c
Application.ScreenUpdating = True

End Sub

HTH

VBA Noob

Adding(Append) fix string before a particular cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Adding(Append) fix string before a particular cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions