+ Reply to Thread
Results 1 to 2 of 2

Merging multiple cells into one cell

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Merging multiple cells into one cell

    I know this is easy but I can not seem to make it work. I am trying to merge information from cells A1, A2, and A3 into A4 with the format of A3, A2, A1. Here is my formula =a3&", "&a2&", "&a1. My problem is that a2 does not always contain data so I am getting 2 commas in between A3 and A1 when A2 does not contain data. Hopefully this makes sense but I need to remove the comma and space that A2 would normally occupy if there is no data there. Like merging a First Middle and Last Name with spaces but deleting a space when a middle name is not listed. jrg

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging multiple cells into one cell

    =if(a3="", "", a3 & ", ") & if(a2="", "", a2 & ", ") & a1
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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