concatenate strings

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...

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...

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???

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.