+ Reply to Thread
Results 1 to 3 of 3

consolidate text not sum

  1. #1
    Registered User
    Join Date
    07-23-2016
    Location
    california
    MS-Off Ver
    16
    Posts
    1

    consolidate text not sum

    hi guys im trying to do something really simple but i don't get how to ... i have a feeling the answer is simple but after trying out a few different tutorials what i find is that they consolidate by adding by im not trying to add just consolidate text
    Foo Bar text
    jp x
    jp________y

    to

    Foo Bar text
    jp x y

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: consolidate text not sum

    Hi jp,

    Welcome to the Forum!

    We'll dispense with the Army Regulations Can you: Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    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: consolidate text not sum

    Consolidate doesnt, I have a feeling you are using +? (you cant add/sum text anyway)

    If that data you shows is 1 word/letter in its own cell...
    A
    B
    C
    D
    1
    Foo Bar text Foo Bar text
    2
    jp x jp x
    3
    jp y jp y

    D21=A1&" "&B1&" "&C1
    copied down
    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

+ 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. Can't consolidate text values
    By vini1508 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-15-2016, 05:16 AM
  2. [SOLVED] Consolidate text data from rows into columns
    By joevan1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-29-2013, 01:10 AM
  3. Replies: 10
    Last Post: 07-18-2012, 07:07 PM
  4. [SOLVED] Consolidate Text
    By Huddle in forum Excel General
    Replies: 3
    Last Post: 04-13-2012, 08:59 AM
  5. [SOLVED] How do you consolidate tables contianing text?
    By samenvoegen van sheets in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 06:10 AM
  6. [SOLVED] Consolidate text
    By EXCEL101 in forum Excel General
    Replies: 2
    Last Post: 02-18-2006, 12:10 PM
  7. How do I consolidate files comprised of only text?
    By joconnorrealty in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-11-2005, 08:06 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