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] 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" …
[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 not working [SOLVED] - Excel Help Forum
Oct 9, 2016 · IF function not working with concatenate By rupes0610 in forum Excel Formulas & Functions Replies: 0 Last Post: 08-09-2012, 11:50 AM
CONCAT stopped working? - Excel Help Forum
Jul 11, 2018 · Re: CONCAT stopped working? CONCAT is not available in 2016 descktop either, so perhaps this was a UDF? what is your file extension?
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 …
concatenate + format color - Excel Help Forum
Sep 15, 2005 · Concatenate only deals with the values of the cells and not with the formats applied to those cells. In order to concatenate and apply colour would require a bunch of code (assuming you …
[SOLVED] Concatenate issues not displaying the date - Excel Help Forum
Feb 20, 2020 · Re: Concatenate issues not displaying the date Dates are, fundamentally, just serial numbers. In cells formatted as dates, they show correctly, but within a concatenated string, they …
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 …
How do I change font attributes in a Concatenate statement?
May 29, 2005 · Excel 2002. I need to change fonts and font colour, within the one cell. For example, begin the cell with a Red Wingding Bullet at 10pt, followed by an Item Description in Arial Black 10pt, …