Adding Parentheses to a Concatenate Formula?? [SOLVED] - Excel …
Jul 1, 2021 · Re: Adding Parentheses to a Concatenate Formula?? Originally Posted by JeanieBob Hello, I realize this post is very old, but in searching for a way to create a …
[SOLVED] Concatenate Month and Year (But not Day!) columns …
Jan 24, 2013 · Re: Concatenate Month and Year (But not Day!) columns into a single column containing the You can use the date function and give day 1 in your formula. Then you change …
concatenate + format color [SOLVED] - Excel Help Forum
Sep 15, 2005 · RE: concatenate + format color 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 …
Concatenate not working [SOLVED] - Excel Help Forum
Oct 9, 2016 · Re: Concatenate not working Delete the formula from the cell, set the cell to general format and then re-enter the formula. Does it now work?
Concatenate long list with punctuation (email list) - Excel Help …
Nov 5, 2015 · Concatenate long list with punctuation (email list) anyone know how I can concatenate a whole column of email addresses into a single cell with "; " (semicolon space) …
Concatenate won't copy down my column [SOLVED] - Excel Help …
Apr 29, 2014 · Concatenate won't copy down my column I'm using a concatenate formula for first and last names ex: =CONCATENATE (A2," ",B2) When I try to drag it down my column from …
CONCATENATE adds quotes - How to suppress? - Excel Help Forum
Jun 1, 2023 · a.) you use a hard Return (Alt+Enter) within the description (and put something on a row below) . . . it puts quotes at the beginning and end of the Concatenate, and b.) if you use …
Concatenate with 2 decimal places - Excel Help Forum
Oct 11, 2016 · Concatenate with 2 decimal places Hi folks, I can get concatenate to work, showing spaces etc., but one of the columns shows a number as 8.30 but in the concatenate …
Concatenate issues not displaying the date [SOLVED] - Excel Help …
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 …
Number Format from Round Function within Concatenate - Excel …
Dec 5, 2011 · I'm using a round function within a concatenate function. I am rounding to 2 decimal places, but if the result has trailing zeroes, the round function will delete them.