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
TEXTJOIN Formula to Concatenate Unique Column Values Good afternoon! I'm trying to concatenate a list of unique values from a range that may or may not be null I have a workbook that combines the disparate datasets into one file, which is then subsequently transferred to one worksheet in another workbook
Keep the leading zeros when cells are concatenated I have a column with numbers such 0044 which I custom format with 0000 so the leading zeros show I have another column with numbers such as 555 When I concatenate the 555 0044 the leading zeros are gone so I get 55544 Is it possible to get 5550044 Thanks
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"
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