concatenate strings

  1. D

    Concatenate with more than one logical test and multiple results

    I'm looking for a way to compare a text string or cell address to a column of possible matches. Then I want to concatenate notes from every row that has a match, but only if a logical test is true. A UDF would be perfect. I've seen one from Rick Rothstein mentioned a couple times now, but I...
  2. G

    Force line break in label that is concatenated

    Dear All, I have a cell where I am stringing text together and want to force a line break/carriage return in the label. I know that if I was purely entering text, I can hit ALT+Enter within the text to force a line break. How do I accomplish this when the text is created using concatenation...
  3. F

    Strings won't join

    Hi There i'm tryin gto use the following in my sub Dim P As String Dim path As String P = Application.InputBox(Prompt:="Please Provide the current year", Title:="Current Period", Default:="example, 10 for 2010", Type:=2) path = "Report Jul"&P&").xls" But I'm getting a Compile, Syntax error???
  4. D

    Optimize If...Else statement

    Hi, Please, help me optimize (make shorter code) the following If...Else statement: You can pass me any variants of statements, loops, number of variables from VB6 or VB.NET.

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