Results 1 to 4 of 4
  1. #1
    Newbie
    Join Date
    January 2nd, 2008
    Posts
    3
    Lightbulb Merging Column data in Excel
    Hi,

    I have data in columns A1 to EL1 in an Excel.
    I want to merge these data in column A1 to EL1 to one single cell.
    Is there any easy way of doing it other than using "&" or Concatenation.

    Thanks
    Bhaskar

  2. #2
    Affiliate Manager
    Join Date
    November 1st, 2007
    Location
    Orlando, FL USA
    Posts
    29
    Why not concatenate? Sounds like it is exactly the solution you need.

  3. #3
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    lol, What is easier than concatenate? The & is your friend
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  4. #4
    Newbie
    Join Date
    January 2nd, 2008
    Posts
    3
    Using this formula for data in 100 plus column is tedious and time consuming. Any macro available?
    And now I want to merge the data in 100 plus column with a comma(,) seperating data in each cell then it will the very time consuming.
    Any other way of doing this....

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Tool to convert excel data to mysql
    By acpd in forum Commission Junction - CJ
    Replies: 5
    Last Post: November 29th, 2008, 11:51 PM
  2. Data feed to Excel problem
    By layla in forum Google Affiliate Network - GAN
    Replies: 2
    Last Post: October 11th, 2007, 07:30 PM
  3. merging columns in excel
    By suzigeek in forum Programming / Datafeeds / Tools
    Replies: 15
    Last Post: July 26th, 2004, 02:59 PM
  4. Opening data feed in MS Excel
    By gjab in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: February 27th, 2004, 04:12 PM
  5. Web Designer (or company) Needed for project (Merging Data)
    By djacks203 in forum WebMerge (Fourthworld.com)
    Replies: 3
    Last Post: December 29th, 2003, 02:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •