+ Reply to Thread
Results 1 to 2 of 2

Concatenate list values without losing previous cell value

  1. #1
    Registered User
    Join Date
    08-09-2021
    Location
    Tunisia
    MS-Off Ver
    365
    Posts
    10

    Question Concatenate list values without losing previous cell value

    Hello,

    I have an excel sheet that contains a list ( 1, 2, 3, 4)

    Can I do this operation :

    when I select "1" from the list, I should have another cell that contains "1"
    AND IF I select "2" from the list, the cell should contain "1 2 " NOT ONLY 2, which means it conserves the previously selected text from the list!
    is this operation possible with Excel?

    I hope you understand the situation.
    Thank you in advance.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,767

    Re: Concatenate list values without losing previous cell value

    Let say list is on B2 and destination cell is D2:

    Capture.PNG


    Please Login or Register  to view this content.
    Check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to find a way to get the previous answer from a list of values
    By JWallz44 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-26-2021, 07:51 PM
  2. Incrementing numbers based on previous values and text values of a previous cell
    By mauricewsylvester in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2021, 12:34 PM
  3. How to concatenate adjacent cells based on values present in previous columns?
    By Palraj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2014, 01:01 AM
  4. List Box to recall previous entered values
    By pfeifferjoey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2014, 11:34 AM
  5. Concatenate values in a column based on value of previous column
    By CountySurveyor in forum Excel General
    Replies: 3
    Last Post: 10-02-2012, 06:38 PM
  6. Keeping the Data, losing the formula (concatenate)
    By arthurz in forum Excel General
    Replies: 3
    Last Post: 02-22-2007, 05:14 PM
  7. [SOLVED] How do I merge cells without losing cell values?
    By Sean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2006, 08:35 PM

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