DNForum - Domain Sales, Domain Forum, Domain Appraisals, Domain Registrars - View Single Post

**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!

05-15-2008, 05:39 PM	#9 (permalink)
Mediamarket Platinum Lifetime Member Name: Troy Last Online: Yesterday 06:42 PM iTrader: (15) Join Date: Nov 2007 Posts: 141 DNF$: 150 Location: US Country:	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!