concatenate function

This is the string that produces a working formula. =CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$B15,",Table_Data[",C$26,"])") C26 - is the header of the table B15 - is the number of days current or before <tbody> The result is a formula that I can paste into notepad, then re-copy into...

Hello, I want to concatenate all words with a space in the same row but some rows has more than 30 columns How can I make simple this formula maybe with function? =CONCATENATE(A1," ",B1," ",C1," "......... until there is text in the cell? Thanks in advance :)

The data I am working with contains blocks of cells in column C, with between 1-10 cells in them, that all have text in them. The blocks represent customer reviews. The last cell will always end with "(hide full review)". I want to write a function that will move through the column and...

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

Hi guys, I need to concatenate the content of 3 cells using the separator "-" but only when cells are non empty The custom function I'm trying to create would look like this : Function ConcatWithSep(Sep As String, Str1 As String, Str2 As String, Str3 As String) As String ... End Function...

Hi everyone!! I'm having an issue here. I've used a formula combining CONCATENATE and IF functions and the results are pulled from another sheet. They're numbers and they were originally entered as simple numbers (i.e. 1000) and then the cell were converted to 'comma style" in order to...

Can someone explain the significance of the following: =Concatenate(CurrentYear, CurrentQuarter) =Concatenate(CurrentYear, CurrentQuarter) * 1