+ Reply to Thread
Results 1 to 4 of 4

Combine cells but one variable remain constant

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Combine cells but one variable remain constant

    Hey guys, I have searched and searched and cannot seem to get this figured out (I do not use excel too often).

    I want to combine two cells but one of the variables will remain constant.

    For example: In column A I will have the words A2 = Fun, A3 = Cold, A4 = Bad. Then I will have another word in another cell such as B1 = Day. I want to combine these words together in their corresponding cells as follows: B2 = Fun Day, B3 = Cold Day, B4 = Bad Day.

    Now, I have used "=A2&" "&B1" and that gives me B2 = Fun Day but when I click to drag that formula down it changes to "=A3&" "&B2". I need that second variable to remain B1 for the entire column.

    Can someone please explain how this is done?

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Combine cells but one variable remain constant

    Hi balexander26
    Welcome to the forum
    add a $ to fix the row to one "=A2&" "&B$1
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    11-10-2011
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Combine cells but one variable remain constant

    Wow, I knew it had to be something soooo simple. Thanks so much for that!

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Combine cells but one variable remain constant

    your welcome

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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