Results 1 to 6 of 6

Combined Cell Values (Text) in 1 Cell?

Threaded View

  1. 03-19-2014, 06:20 PM #1
    Rick-O-Shay
    Rick-O-Shay is offline
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2003, 2010, 2016, 2019, & Office 365
    Posts
    194

    Combined Cell Values (Text) in 1 Cell?

    Hi,

    If I have text in B1 (Apples)
    And text in C1 (Bananas)

    How do I write a formula in cell A1 that will combine the text of both so that it reads 'Apples Bananas' in cell A1?

    Everything I can think of gives me errors.

    Thanks,
    Last edited by Rick-O-Shay; 03-19-2014 at 06:37 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If cell A of Row 1 = cell A of Row 2, then combine text values for cell B of both rows
    By loosemarble in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2013, 02:41 PM
  2. if cell values are same,then combined it.
    By johncena in forum Excel General
    Replies: 2
    Last Post: 03-07-2010, 10:20 AM
  3. text and number combined in a cell
    By TimN in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2006, 06:05 PM
  4. [SOLVED] How can I remove diff. numbers from a cell combined with text
    By Greg in forum Excel General
    Replies: 5
    Last Post: 02-28-2006, 04:10 PM
  5. [SOLVED] UDF code to find specific text in cell comments, then average cell values
    By bruch04 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1