+ Reply to Thread
Results 1 to 3 of 3

Help merging Cells

  1. #1
    Registered User
    Join Date
    03-21-2016
    Location
    glasgow
    MS-Off Ver
    office 2013
    Posts
    1

    Help merging Cells

    I have a spread sheet that holds client property details, some properties are held singly others are held jointly.

    I would like to be able to create a new column entitled "ClientSalutation" that will record either "Client1Firstname1" or "Client2Firstname" or "Client1Firstname and Client2Firstname" as the correct way of addressing correspondence to them.

    I had looked at using the =a1&" and "&b2 formula in the "ClientSalutation" column but this adds the "and" to a record where the property is held in a single name only .

    Is it possible to create formula that will allow Excel to recognise where Client2Firstname is empty and therefore not include "and" in the "ClientSalutation" column thus creating the correct entry in the "ClientSalutation" column.

    Cheers

    Stuart

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Help merging Cells

    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 (or use the paperclip icon).
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Help merging Cells

    Assuming Client1FirstName1 is in column A and Client2FirstName is in Column B then in Client Salutation try the formula:-

    =IF(A2="",B2,IF(B2="",A2,CONCATENATE(A2," and ", +B2)))
    Last edited by FoxSeaLady; 03-21-2016 at 10:46 AM.

+ 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. [SOLVED] How to combine similar cells, while merging data in other cells
    By Sut703 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-27-2014, 04:17 PM
  2. Merging Cells
    By slxia1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2012, 08:08 PM
  3. Replies: 6
    Last Post: 01-15-2012, 08:57 AM
  4. Merging cells/merging cell content.
    By rhintintin in forum Excel General
    Replies: 3
    Last Post: 09-23-2010, 10:42 AM
  5. Merging Cells below each other
    By alsoknownas in forum Excel General
    Replies: 4
    Last Post: 11-25-2008, 11:17 AM
  6. Merging Cells
    By allysvmw in forum Excel General
    Replies: 1
    Last Post: 12-13-2007, 06:22 AM
  7. Merging cells
    By sonic in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-16-2005, 09:08 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