+ Reply to Thread
Results 1 to 3 of 3

Merge Cell Keep Text

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    72

    Merge Cell Keep Text

    Hi Guys,
    Hi have content in Column A1,B1 and i need to merge the cells as A1 has the first name and B2 has the second but there is 39 names is there a macro that can keep the content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Merge Cell Keep Text

    Does putting this formula in cell C1 help?
    Please Login or Register  to view this content.
    If yes, then copy the formula for all the rows?

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Merge Cell Keep Text

    In C1 Cell

    =A1&" "&B1

    Drag it down..


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. merge together all the existing text in one cell?
    By termal in forum Excel General
    Replies: 5
    Last Post: 07-09-2010, 09:03 AM
  2. Merge cells if cell contains certain text
    By mr63249 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2008, 09:41 AM
  3. wrapping text in merge cell limit
    By Ivano in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 10:13 PM
  4. merge several cells with text into 1 cell
    By chum in forum Excel General
    Replies: 4
    Last Post: 07-25-2006, 11:35 AM
  5. text continuing in next row in a merge cell
    By Peyline in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2006, 03:44 AM

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