View Single Post
Old 05-09-2007, 11:44 AM  
ModelPerfect
Confirmed User
 
Join Date: Nov 2003
Location: USA
Posts: 2,862
Excel: Put each list in two separate columns (A, B), then in column C use the formula

=concatenate(A1,B1)

Copy/paste the formula all the way down and you're done. (you can then copy/paste into notepad without the spaces).

---

OR

---

Notepad: if you copy/paste the two columns and end up with the spaces, like you mentioned, simple find & replace all instances of " " with "" and the spaces are gone.

---

People are making this way too difficult.
__________________
Logan
modelperfect [at] gmail.com
http://www.modelperfect.com

(Proudly hosted at www.webair.com )
ModelPerfect is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote