Jun 14, 2011 · I have two cells in Excel. one has a string and the other one has a date. in the third cell I want to put the date and the string together. For example: A1 = "This " A2 = "03/03/1982" …

Mar 15, 2017 · To create text values longer than 255 characters in a formula, use the CONCATENATE function or the concatenation operator (&). I have been looking this up online …

How do I concatenate cell values and text together using Excel VBA? Asked 10 years, 3 months ago Modified 8 years ago Viewed 85k times

I've got a long spreadsheet with numbers. I need to get them in one string delimited by ; e.g. 4364453;24332432;2342432 I know I can do: =concat(A1:A2000) but that will merge it in one …

Is it possible to concatenate a range of values, based on a value in another column? Asked 4 years, 1 month ago Modified 4 years, 1 month ago Viewed 9k times

Jan 23, 2020 · There is the concatenate function. =CONCATENATE(E2,"-",F2) But the & operator always concatenates strings. + often will work, but if there is a number in one of the cells, it …

Jun 9, 2022 · There is another way, though more for " How can I construct the following string in an Excel formula: "Maurice "The Rocket" Richard" " than " How to create strings containing …

Nov 30, 2022 · I have a column containing single characters, and want to concatenate them in reverse order. How can this be accomplished in an Excel formula, without explicitly providing …

Oct 8, 2015 · How to concatenate strings from hundreds of cells? Asked 12 years, 5 months ago Modified 10 years, 2 months ago Viewed 9k times

Sep 7, 2012 · 1 easier answer - put the stuff in quotes in different cells and then concatenate them!