Retaining formatting in concatenate function - Microsoft Community
May 31, 2010 · I want to concatenate different cells. Two of the cells I concatenate have percentages, one showing a negative percentage in red. I seem to lose the formatting when I …
concatenate function to form hyperlink - Microsoft Community
Jul 10, 2025 · concatenate function to form hyperlink Hi Guys, I need you help to resolve one of my problem facing with my large database developed in MS Excel.
Concatenate is not working with Hyperlink - Microsoft Community
Oct 21, 2024 · Here is a simple example: Suppose column A contains the recipient email addresses, and cell B1 uses the concatenate function to combine the email addresses in …
=CONCATENATE formula NOT Copying properly when pulled …
Oct 26, 2015 · Problem: The title developed into a rather long =CONCATENATE formula It operates fine in the cell I created it in and returns the expected result; however, When I try to …
Can't combine cells using CONCATENATE or CONCAT
Dec 11, 2017 · I get the #VALUE! error when trying to combine cells using the CONCATENATE formula and then when I try CONCAT (like help says), it gives me the #NAME! error because …
When I go to use the concatenate function it has an exclamation …
When I go to use the concatenate function it has an exclamation point in a yellow triangle I put in the entire formula and instead of actually doing anything, it just shows the formula in the box. I …
Combining CONCAT with IF or VLOOKUP? - Microsoft Community
Hello! I am trying to write a formula that will allow me to concatenate cells based on whether or not they share the same value in another cell in the same row. Basically, we have customers …
date in a formula different from the real value in the cell
Jun 12, 2023 · Hi all, I have an issue with the formula concatenate. In the Excel file I have a column with the date format yymmdd. I want to combine this date with another value using the …
Using CONCATENATE formula as LOOKUP value un VLOOKUP …
Mar 6, 2015 · Using CONCATENATE formula as LOOKUP value un VLOOKUP formula. Works if number typed in but CONCATENATE formula resulting in same number gives error
How to conditional formatting in concatinate function used cell (in …
Nov 10, 2022 · Concatenate function using more separate cells are merge in single clell. i need how to conditional format for combined cell in middle value or last value or first value alone.