Retaining formatting in concatenate function - Microsoft Community How do I concatenate the examples below with variable length text? The price is $998 53 per piece The price is $1,002 18 per piece The price is $1 00218 per 1000 pieces The bold or italic above could be any combination of bold, italic, text color or background color
When I go to use the concatenate function it has an exclamation point . . . CONCATENATE is, “to join two or more text strings into one string” I suspect that the yellow triangle’s there because according to the link I’ve provided in the line above, “ This is because CONCATENATE may not be available in future versions of Excel
concatenate shows formula rather than the results I am attempting to concatenate first and last name fields into one name using Concatenate I have been doing this for 20 years But recently Excel has been displaying the formula rather than the
=CONCATENATE formula NOT Copying properly when pulled down - Please . . . It was a =CONCATENATE formula drawing information from different sheets and locations and inserting an "*" 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,
Concatenate with formatting on specific text or numbers =CONCATENATE("There is a minimum monthly fee of $",(Pricing!P5)," At any point if the sum of Customers user fees falls below the minimum monthly fee, the minimum monthly fee will be charged ") Where it says (Pricing!P5) from info I am pulling in from another worksheet, I want this number being pulled into this string of text to be bold and
VLOOKUP and CONCATENATE together - Microsoft Community VLOOKUP and CONCATENATE together I have a huge database of information that returns first and last name in different columns The worksheet I am creating needs to be able to combine the first and last name once the employees ID is entered "lastname, firstname"
Copying and Pasting Concatenated Cells - Microsoft Community First, thanks to all the folks who directed me to Concatenate to solve a problem It was just what I needed But another problem has come up I need to copy and paste the column of concatenated results to another workbook The simple copy and paste way does not work There are several questions from others with the same problem