Adding a word to the end of other words at the same time

[phil]

I was wondering if there was a way to add a word to the end or
beginning of multiple other words in Excel. Example; say I have these 3
words....
Alpha
Beta
Tera
Now I want to add LLC to the end of each word but I want to change them
all at the same time. Like
Alpha LLC
Beta LLC
Tera LLC
Is there a way to do that?

Phil

 

[phil]

Its Excel 2003

 

[Don Guillett]

try

Sub addtexttoend()
For Each c In Selection
c.Value = c & " xxx"
Next
End Sub

 

[phil]

Is that a macro? how do I set that up?

 

[Gord Dibben]

Phil

Assumes your data is in column A and the formula is entered in B1.

=A1 & " " & "LLC"

Drag/copy B1 down as far as you have Data in column A

When happy with results, copy column B and, in place, Paste
Special>Values>OK>Esc.

Now you can delete Column A if so desired.


Gord Dibben Excel MVP

 

[RompStar]

the first example was a macro, I strongly recommend that you learn VB
and Macros, they can do
magic, I am still learning my self.

If you don't know VB or how to use macros, use Gord Dibben examples,
that just uses helper columns
and formulas, dones't require VB scripting.