names in formulas

  1. N

    Concatenate multicoulmns but not display blank coulmns in the total formula

    <tbody> B C D E F 1 SURNAME FIRSTNAME MI GENQUAL CONCAT'D 2 DOE JOHN T JR DOE.JOHN.T.JR 3 DOE JANE DOE.JANE </tbody> I cant figure out how to write a formula to concatenate column B thru Column E, add a period after each column, but not display a period if the field is blank. In the...
    • NGB82KS
    • Thread
    • blank column concatenate display names in formulas
    • Replies: 8
    • Forum: Excel Questions
  2. G

    Applying names to an existing formula?

    Hi I have defined a global name in sheet A. I want to apply it to an existing formula in sheet B. I am using excel 2010. I place the cursor on the cell with the formula that needs changing. The normal approach of doing "Define Name", "Apply Names" does not work. I get the "Microsoft Excel...
  3. P

    Concatenate formula questions about First Name Last Name and spaces not matching

    I have a spreadsheet containing 3 columns, First Name, Nickname and Last Name. In a separate column, I concatenate First Name and Last Name as =PROPER(D2&" "&F2) to return the following: Jane Doe It appears that there are many spaces between between First Name and Last Name even...
  4. S

    Function to Add Cells if name exists

    I am working on a VBA program and have several VBA projects that create cell names if the area exists. For example- I filter data from one sheet to another based on a category number. At the end of that data set I complete several Sum functions to sum the data above. The sum data cells are...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top