concatenated

  1. R

    Formula Question

    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...
  2. gheyman

    Concatenate formula

    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...
  3. P

    How to remove certain parts of text in an already concatenated column

    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...
  4. L

    Concatenate a string of text from one col., from corresponding text in another col. that matches a cell

    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...
  5. T

    Concatenated hyperlink

    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...
  6. A

    Can the LOOKUP_VALUE in a MATCH function be CONCATENATED?

    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
  7. V

    VBA: Remove special indentation (hanging indent)

    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...
  8. B

    Vlookup, concantenate multiple results... Help!

    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...
  9. geofspa

    Ugly Formula - Prettification please

    :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...
  10. D

    Concatenate and Wildcards Problem

    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...
  11. D

    Concatenate 2 cells followed by a blank

    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
  12. D

    How to produce concatenated cell drawing from a changing source range

    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"...
  13. C

    How do I join result of two formulae in 1 cell?

    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
  14. E

    Make min/max formulas read concatenated data?

    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...
  15. T

    Find data from a column and see if it matches the concatenated equivalent to 3 columns

    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...
  16. P

    Concatenate based on duplicate cells in different rows.

    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...
  17. T

    Hyperlink concatenated exceed 255 characters

    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...
  18. J

    VBA to autofill range of cell, part of formula is concatenated string from referenced range

    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...
  19. P

    VBA identify unmatched data

    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...
  20. D

    Pass concatenated string + variables as Range?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top