+ Reply to Thread
Results 1 to 6 of 6

Concatenate Formula not working for all rows

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2011
    Posts
    1

    Cool Concatenate Formula not working for all rows

    Hey all!

    Excel Newbie here! I am trying to create a mass mailer using information that I collected on an Excel spreadsheet. I am having a major problem with the concatenate formula. When I plug in the formulate for the individual row, Excel spits out the correct information/format that I want.

    The problem is that when I drag that formula to other rows, Excel just maintains the same information. So, I guess the problem is that Excel isn't automatically changing the formula that I had created. In the box that I have the formula in, I drag down the lower right hand cross down to all the rows that I want Excel to apply the formula to, but it's still the same info!

    I have a feeling that this should be a simple fix. Maybe there's something wrong with the settings or something.

    I am attaching a screenshot of what the issue is!

    HELP and THANK YOU!

    Jennifer
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Concatenate Formula not working for all rows

    it would have been easier to help you if you had uploaded the sample file, rather than a picture (cant see your other formulas in a pic). however, when i want to join cells/text together, i prefer to use the & instead. so your formula (which btw, looks lie it should copy down and work fine) would be...

    =G3&" "&C3&" "&D3&E3&" "&F3

    try tha and let me know how you make out. if it doesnt work, please upload the actual sample file
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Concatenate Formula not working for all rows

    I see you are using Excel 2011 (Mac)! Probably makes no difference.

    Are you sure the cells are not Absolute!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Concatenate Formula not working for all rows

    @ Kevin in the pic he gace, the formula highlighted shows no absoluting?

  5. #5
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Concatenate Formula not working for all rows

    @ FDibbins

    Yes, I noted the cells were not absolute when I first open the picture up. But you never know, strange or unexplained things occur in life!
    Perhaps the OP should upload a some sample data, as by his picture it works for me.

    Kevin

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Concatenate Formula not working for all rows

    @ Kevin, i agree, and have suggested that to the OP as well

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1