Excel: Use formula longer that 255 characters - Stack Overflow
Mar 15, 2017 · I have the following formula in excel =CONCATENATE("insert into #UpdateData (mondayopenhour, mondayopenmin,mondayclosehour, mondayclosemin,tuesdayopenhour, …
How do I concatenate a range of cells into a single cell in Excel?
Apr 1, 2025 · Use CONCAT instead of CONCATENATE to combine the results into a single cell. =CONCAT(A2:C2) According to Microsoft's documentation, CONCATENATE was replaced by …
Microsoft Excel - How do I keep dd/mm/yyyy format while using ...
I'm trying to bring together string values using the CONCATENATE function in Excel. When I try include a date (source formatting is dd/mm/yyyy) it converts to Number type data and I've no …
Excel/VBA: Variable Value/Text into concatenate formula
Aug 17, 2017 · Excel/VBA: Variable Value/Text into concatenate formula Asked 8 years, 3 months ago Modified 8 years, 3 months ago Viewed 15k times
excel concatenate with "²" or squared symbol - Stack Overflow
Dec 25, 2021 · I would like to use a concatenate formula in Excel that also includes the superscript number 2 (squared symbol), but this does not work with the following input. The …
Concatenate function in Excel 2010 to add single quotes and …
Mar 26, 2017 · 14 I am working on a loaner laptop and have found that the concatenate function I have used to add single quotes and a comma to a column of text is no longer working. I need …
excel - Concatenate repeats first row cell values even though …
Sep 30, 2015 · Concatenate repeats first row cell values even though formula selects different cells Asked 10 years, 1 month ago Modified 5 years, 8 months ago Viewed 11k times
How can I turn a CONCATENATE formula into a hyperlink?
Mar 10, 2020 · How can I turn a CONCATENATE formula into a hyperlink? Asked 5 years, 7 months ago Modified 5 years, 7 months ago Viewed 5k times
vba - Bold text in a Concatenate formula - Stack Overflow
May 10, 2018 · I would like to be able to make one or two specific words bold in my sentence when using a concatenate formula. An example is shown below. The first sentence is using …
Concatenate numbers separated by dash while keeping leading …
Aug 8, 2014 · The below code works perfectly. It concatenates the columns and retains the leading zeros from each column: = A2&B2 However, I need a dash between the values. When …