how to use concatenate and round function in one formula
Nov 26, 2011 · in call A1 i have value i enter in A1 is =2/3 and in A2 =CONCATENATE(A1,"x") which gives this value =0.666666666666667x but i want only 2 value after decimal + "x" is there any want …
How to use CONCATENATE and SUBSTITUTE formula together?
Nov 1, 2009 · Is this possible because when i try to use the Substitute formula my Concatenate formula is doesn't work. This data in cell A1 is linked from another sheet...
CONCATENATE within a SUM forumla | MrExcel Message Board
Jun 3, 2011 · First off, you do not need to use the CONCATENATE function, just link your items together with an ampersand. Your posted CONCATENATE formula can be written like this... ="B"&RIGHT …
INDIRECT and CONCATENATE with dynamic Cell reference
Apr 14, 2017 · I use match array function to figure out which column I need to pull (I can pull both number or column letter) but I don't know how to replace that to the Cell function and still make it …
Combining Filter function with Indirect/Concatenate to look ... - MrExcel
Apr 4, 2024 · Combining Filter function with Indirect/Concatenate to look up from another worksheet wilsonb78 Apr 4, 2024 across sheets concatenate dynamic excel365 exclude blanks filter indirect
How to remove certain parts of text in an already ... - MrExcel
Aug 8, 2019 · Good Morning, I need to remove certain text from my line that has already been concatenated. For Example...This is the concatenated version: 2014 Great Dane Van I need to …
Combine two columns into one, with a hyphen - MrExcel
Jan 2, 2005 · Hello again. I recently received help splitting one column into two using the DATA>TEXT TO COLUMNS>DELIMITED ability. I have now found myself wanting to combine two other columns …
Apostrophe in Concatenation | MrExcel Message Board
Jul 17, 2005 · Hi, This will probably seem like a very simple query, but I am trying to concatenate 2 columns of excel. One contains dates of birth and the next one...
Combine =CONCAT and =HYPERLINK? | MrExcel Message Board
Oct 8, 2020 · So can I/what ONE formula can i use if i just have microsoft.com or google.com or ibm.com in cell B2 that COMBINES =concat and =hyperlink so that I can launch the website from …
how to bold part of a concatenate formula - MrExcel
Mar 27, 2013 · Live Online Excel Training for Your Team from MrExcel. Bring MrExcel to your people. Two hours. High-impact. Zero travel. Click here for details.