excel question.... - DNForum - Domain Sales, Domain Forum, Domain Appraisals, Domain Registrars

**picassoface** · 05-15-2008, 04:59 PM

Let's say I have a group of names in column A :

philly
boston
japan
denver
germany
etc....

And I want to put the same word, like, "trips" on the end of each word without having to type trips over and over... Is there a way ? Thanks

**theinvestor** · 05-15-2008, 05:01 PM

You can put the word "trips" in each column simply by dragging it down.

but i think that will replace any words you already have in column A.

**jdk** · 05-15-2008, 05:02 PM

Column B you can type trips and drag the right-hand corner down to fill Column B with trips. Then take and select all of Column A and Column B and Copy. Paste it into Notepad. Copy the space in Notepad and go to Edit > Replace. Paste in the "blank" space and hit Replace.

Now you have a list with wordtrips

**picassoface** · 05-15-2008, 05:03 PM

Brilliant !

Thanks

**draggar** · 05-15-2008, 05:04 PM

What JDK said but I am not sure if it will work with Notepad but it will work with WordPad (also a freebie w/ Windows) and Word.

Just remember to save it in a format you need (.txt) or after you're done, copy & paste back into Excel.

**jdk** · 05-15-2008, 05:04 PM

Quote:

Originally Posted by draggar

What JDK said but I am not sure if it will work with Notepad but it will work with WordPad (also a freebie w/ Windows) and Word.

Just remember to save it in a format you need (.txt) or after you're done, copy & paste back into Excel.

Notepad works fine. The other suggestions you made will work too.

**lostcoin** · 05-15-2008, 05:32 PM

I realize you've already solved your problem, but in case anyone else is wondering about a similar problem, I think you can use a formula which uses the ampersand (&) symbol to combine values from different cells.

So for example, if "blue" is in A1 and "trips" is in B1, you can type

=(A1&B1) into column C and it will combine values into "bluetrips".

(and then fill down as appropriate).

Anyway, hope that helps!

**jdk** · 05-15-2008, 05:35 PM

Quote:

Originally Posted by lostcoin

I realize you've already solved your problem, but in case anyone else is wondering about a similar problem, I think you can use a formula which uses the ampersand (&) symbol to combine values from different cells.

So for example, if "blue" is in A1 and "trips" is in B1, you can type

=(A1&B1) into column C and it will combine values into "bluetrips".

(and then fill down as appropriate).

Anyway, hope that helps!

Ah it is the &. I was doing +

Anyways if you are doing that you can have your names in Column A and then in Column B Do the following.

In B1 put =A1&"trips"

Then drag the bottom right corner of B1 down and it will take and add trips to all the words

**Mediamarket** · 05-15-2008, 05:39 PM

Another way I use is the CONCATENATE function.

So in B1 you can use the following formula and then drag the formula down and it will take whatever is in column A and then add "trip" to the end.

=CONCATENATE(A1,"trip")

You can add ".com" or whatever text you want to your original list.

It also works for taking the text from two cells into one =CONCATENATE(A1,B1) ( =(A1&B1) works for that just as well)

Hope that helps someone!

**theinvestor** · 05-15-2008, 05:41 PM

Thanks media! That's really helpful just tried it out.
Learn something new every day.