concaatenate

  1. F

    Concatenate

    hi, how to write CONCATENATE function to connect 3 fields (AM, AN, AO). For i = 5 To x_ws1_rows ws1.Range("AK" & i).Value = ws1.Range("AG" & i).Value day1 = Day(ws1.Range("AK" & i).Value) ws1.Range("AM" & i).Value = day1 month1 =...
  2. H

    Multiple Conditional IF with the ability activate/deactivate a condition

    Excel 2007 How do I make a multiple conditional formula have the ability to active/deactivate a certain condition dynamically. The example below should clarify; I have the following formula: =SUMPRODUCT((Building=$B15)*(Unit_Type=$B16)*(Unit_Line=H15),Rent_Month_Total) This formula sums the...
  3. B

    tracking numbers input and dropdowns

    I work for a church food bank that calls groups of people. they need a better way to display and track what random group numbers are called and how many families are served every day. im trying to make this easier because they are manuall entering this into notepad on an overhead projector and...
  4. A

    Concatenation of cells

    Hi, I am looking for a VB script to concatenate 3 columns as below: A B C abhimanyu Nagpal ECE The output i want in A1 would be a single string with comma in the end of value from column C. Cell B1 and C1 values get deleted. A B...
  5. N

    CONCATENATE two cells to generate the validation source

    Must be 2007 compatible. I have a table with more than 50 columns and over 3,000 rows. I need users to update multiple columns of data with valid values. Each cells needs to offer different dropdowns based on their values. Let me try to explain: NameRanges: USA_Prefix (all of the...

Watch MrExcel Video

This Week's Hot Topics

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
Top