[SOLVED] Adding Parentheses to a Concatenate Formula?? - Excel Help …
Jul 1, 2021 · FDibbins - I thought excel replaced concatenate with concat (although both still work the same, as far as I can tell). Based on that, not sure why it would be necessary to use "concatenate" …
Adding sequential numbers to the end of a concat string of cells
Oct 16, 2024 · Re: Adding sequential numbers to the end of a concat string of cells Welcome to the forum. There are instructions at the top of the page explaining how to attach your sample workbook …
CONCAT Formula NAME? Error [SOLVED] - Excel Help Forum
Jul 6, 2021 · Help with formula: Concat All on Excel 2007 By egburrough in forum Excel Formulas & Functions Replies: 11 Last Post: 06-29-2016, 04:18 AM
[SOLVED] looking for alternatives to the CONCAT function - Excel Help …
Jun 10, 2024 · Re: looking for alternatives to the CONCAT function TEXTJOIN isn't in Excel 2013, though - see the last line of the opening post.
[SOLVED] Concat format/formula issue and dropping zeros - Excel …
Jul 20, 2023 · Re: Concat format/formula issue and dropping zeros You're welcome. It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members …
CONCATENATE adds quotes - How to suppress? - Excel Help Forum
Jun 1, 2023 · Nope, that misses it. The above issue happens when: a.) you use a hard Return (Alt+Enter) within the description (and put something on a row below) . . . it puts quotes at the …
concat dynamic arrays via IDs [SOLVED] - Excel Help Forum
Nov 15, 2023 · concat dynamic arrays via IDs Dear Friends: The scenario is as follow. In G3# I have a dynamic array, 2 cols, with an ID, and a value1. in J3#, another dynamic array, 2 cols, with an ID, …
Can you preserve formatting like bold and color when concatenating
Excel 2007 in Windows 10. I wish to concatenate the text data in 2 columns. That is easy to do using the formula =CONCATENATE (A2, ". ", B2). My question concerns preserving the existing text formatting …
=_xlfn. error is coming in formula when i open it in older versions ...
Jul 30, 2019 · I used the formula CONCAT (NUMBERVALUE (G2),"_",NUMBERVALUE (F2)) in Excel 365. But my colleagues are havindg the older version of Excel.But When they open the formula is …
=Concat date coming over as numbers - Excel Help Forum
Jun 13, 2023 · Re: =Concat date coming over as numbers Other than the TEXT () function, I'm not aware of any other way to convert a number to a text string in a specified number format (in this case …