+ Reply to Thread
Results 1 to 5 of 5

joining text into one cell

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    mississauga, on
    MS-Off Ver
    Excel 2007
    Posts
    20

    joining text into one cell

    I would like to join text from different cells into one cell. This is for Google sheets. I tried concatenate and join. But they don't seem to work. I realize that it can be done using the & function but it would bea drawn out equation since I have multiple multiple cells to join.

    Sample spreadsheet. ..

    A B
    1 john 2321
    2 Cindy 5543
    3 Bob 4665
    4 Mike 5543
    5 Sean 4356
    6 Vince 5543
    7 Walter 6667

    I would like to know the formula to combine all the instances of 5543 into one cell. For eg. The outcome would be VinceMikeCindy

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: joining text into one cell

    Hi

    Take a look to this.

    http://www.excelforum.com/tips-and-t...geravatar.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: joining text into one cell

    It would be like so:
    =JOIN("",filter(A1:A7,B1:B7=5543))
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  4. #4
    Registered User
    Join Date
    06-22-2012
    Location
    mississauga, on
    MS-Off Ver
    Excel 2007
    Posts
    20

    Thumbs up Re: joining text into one cell

    Solved! Thanks so much. Was not familiar with the filter function.

  5. #5
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: joining text into one cell

    It is very good - I wish Excel had these functions!

+ 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. Joining the text contents of a cell in a row into one cell via a macro?
    By gjjh25 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 07:19 AM
  2. Joining Text at a specified point!
    By leapyleigh in forum Excel General
    Replies: 1
    Last Post: 05-12-2008, 08:52 PM
  3. Joining text in columns
    By yorkshirekid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2006, 02:18 PM
  4. Joining text strings
    By nh1234 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2006, 05:11 PM
  5. Joining Text from two Cells into One
    By Juan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-24-2006, 09:41 PM

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