excel question....

[picassofacepicassoface is verified member.]

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]

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]

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

 

[picassofacepicassoface is verified member.]

Brilliant !

Thanks

 

[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.

 

[jdk]

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]

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]

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]

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]

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