concatenated

Hello, Having an issue, currently using Excel 2016, formula's only work when I overwrite a concatenated formula by manually updating those fields with the exact same data that was being auto populated. I am using this as a small database, for 800 numbers, concatenating the base 800 numbers...

I have a list of items down column B. The number of items in column B will vary from time to time. I am trying to concatenate each row in B (concatenate(B17","B18,".... I need them concatenated No spaces and separated by a "," My problem is how do I only concatenate down the list to where...

Good Morning, I need to remove certain text from my line that has already been concatenated. For Example...This is the concatenated version: <tbody> <colgroup><col width="144"></colgroup><tbody> 2014 Great Dane Van </tbody> </tbody> I need to remove "20" and also remove the...

The goal is to have a concatenated list separated by commas, based on a different list that matches a certain cell. All of which are text. sheet 1 contains two lists; (I need to keep these lists whole) first list has individual items (which will be concatenated) second list which is...

Hi I am trying to figure out a concatenated hyperlink. =HYPERLINK(CONCATENATE("[CSUL.xlsx]",A12,"!A7"),"Goto") This is what I have got so far it links to the workbook CSUL.xlsx but not the Sheet and Cell. The sheet name is in Cell A12. I think this is a problem with Parenthesis. If not...

Can the lookup_value within a MATCH function use the Concatenated value of two cells to identify the COLUMN number of a spreadsheet? MATCH(lookup_value, lookup_array, [match_type]) Something like this is what I'm attempting : MATCH(CONCAT(A1,"-"B1),Sheet2!$3:$3,0) Airic

I have a slide in a PowerPoint presentation ("myPresentation") with some text in a shape. I want to add more text to this. In order to do this, I have stored the old text in a variable, wrote my new text and concatenated it with the variable (see below). myPresentation.Slides.InsertFromFile...

Good Morning All, Having trouble getting multiple results from a Vlookup. Using Excel 16. Have list with po numbers and they have multiple tracking numbers. Would like to be able to look up po on separate sheet and have all the associated tracking numbers concatenated there... Maybe i should...

:confused: I have a spreadsheet that will concatenate up to 50 cells in a column and return the result. The result returned depends upon the first empty cell in the column to be concatenated, I have the concatenation covered but to return the result I have one horrid looking formula - as...

Hello! I've concatenated some cells in order to use VLOOKUP. So for example, I concatenated Oklahoma with Alabama which gives me OklahomaAlabama so when I use VLOOKUP I get the desired result. However, I'm getting results from cells with data such as OklahomaSouth Alabama which I don't need...

Hello! I'd like to concatenate the 2 cells in A2 and A3 but not A3 and A4, which I'd like to leave blank. Cells A3 and A4 would be concatenated, followed by a blank cell in A5. Is it possible? Thanks in advance. A B a ab b c cd d

See image below. I have several groupings of stock symbols -- the group they belong to changes on a daily basis, so the GROUP value in column A will change regularly. I want a formula that will produce the values in cells E2, E3, and E4...in other words, I want all of the symbols in "Group 1"...

Hi. I have a formula that returns a value A (e.g. 2.3E-03) and a different formula that returns value B (e.g. 4.5E-03). I would like the cell to read (2.3E-3 - 4.5E-03). I know that text can be CONCATENATED but this doesn't work for numbers/formulae. Is there away to do this? Thanks Paul

Hi everyone, How would I go about using min/max formulas with concatenated data? For example... I have two or more cells that are concatenated and I want to use min/max on formulas on them. There will be text as well as numerical values. "Owners" which would be text and and a "height" which...

I have 3 columns with the following values: A B C 1 8 2 2 5 4 3 2 6 In column F I have the following data with a separator of | between the values. 1 | 3 | 4 3 | 2 | 6 I want to find if the values column F are in the concatenated equivalent of each record in ABC above. I know I could...

Hi folks, I have i list that shows in column A the title and in column B the topic. This list is generated by an external system and unfortunately that system generates a new row in case a title has multiple topics. I want generate list that has no duplicate titles and shows the topics...

Hello guys, First thank you for this great forum and all informations ! Well, I will explain my issue. I need to open a Hyperlink concatenated in a cell (by example A1) who exceed 255 characters. I tried a lot of VBA, macros and all have an issue... The cell must be clickable and show a...

I have a workbook that I use each month, each year and I have to do a number of different things to it in order to ready it for the next month's use. I'm trying to get the workbook to take care of itself, so to speak. This is one of the steps I'm trying to automate. I have 6 tabs within the...

I need to automate a way to look at two tables and within those two table, concatenate two columns. Where there is not a match to put the unmatched information at the bottom. i.e. I have one ws labeled "ChargeDetail", with columns C and D needing to be concatenated. then compare this...

I'm having hard time getting this to work: Dim lastRow As Long Dim results_range As Range Dim column_results As String Dim wsDATA As Worksheet Set wsDATA = ThisWorkbook.Worksheets("DATA") With wsDATA Set results_range = .Range(column_results & "2:" & column_results & lastRow) End With the...