1. A

    concatenate code I get run time Error

    Hi All Sub concatenate() Dim a As String: a = "L:\OWL\Work" Dim b As String: b = "\jobs" Dim c As String Dim d As String c = Cells(0, 3).Value d = a & c & b Worksheets("sheet 2").Cells(1, 5).Value = d End Sub
  2. Z

    Need Help Converting this Formula to Use CONCATENATE Instead of &

    I am stuck trying to convert this dynamic formula to use the CONCATENATE function instead of the &s. I am using an Excel add-in that does not accept "&" in formulas. I have tried several times to do this myself but cannot figure out what I am doing wrong. It doesn't seem to play nicely with the...
  3. J

    concatenating and formatting dynamic number of strings

    So here is what I'm trying to accomplish. There is a number out to three decimals in column A. Date in column B (mm/dd/yyyy). Say I have this data: <tbody> 2.300 8/1/2018 2.400 9/1/2018 2.850 10/1/2018 </tbody> I want to concatenate this strings to where I get a single string of "2.33...
  4. 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...
  5. A

    Dynamic Vlookup referencing file name tied to a dropdown menu

    Hello All, I am trying to use a Vlookup that when I change an option from the dropdown menu the table changes the range ( A1:A15 to A17:A24) in the source file for the tab and base file name are the same but February will change to March, then April. I am trying to use this formula pieced...
  6. T

    Help! Not sure how to add then show % using cells with text and numbers

    I need row 25 of my s/s to show the % complete for the columns B through G, by columns and then overall % in column H. Is there a formula that it updates every time I change an item?
  7. S

    Concatenate every 100 rows into one cell with VBA

    Hi Friends, Trying to concatenate every 100 rows into one cell =Concatenate(C1:C100) =Concatenate(C101:C200) =Concatenate(C201:C300) and so on. I have 50K rows to concatenate/combine cells Above formula is not working. I know that VBA macro can do this task. Every time I have to specific...
  8. K

    Concatenate/Date array/Min Max Issues

    I dump a large amount of data with different service dates in each column. The dates are pasted as text. In the next columns, I convert the text to dates. I then have a column to find the min and another column to find the max. There can be up to six service dates in my data. I'm trying to...
  9. K

    VBA Concatenation help

    Hi. I wish to concatenate a list if it meets a specific requirement. The code that works when entering into excel worksheet looks like this...
  10. D

    Concatenate all cells in a column up to the 1st cell that is empty

    I am trying to concatenate all the cells in a column up to the 1st cell that is empty. So in cell A1 where it says "FORMULA", this is the cell I want to have the results as "Excel is really a lot of fun." or A2+A3+A4+A5+A6+A7+A8. <tbody> A B C 1 FORMULA 2 Excel 3 is...
  11. M

    Concat Sub or Function no defined

    Hi, I am trying to get this if statement with a concat formula to work, but I keep getting the message "Sub or Function not defied." The worksheet where I am trying to get this formula to run on is titled "Report." Thank you in advance for the help. Below is the code If Range("L4") =...
  12. D

    How do I change the color of the number in a concatenated text string to a different color?

    For instance with: =CONCATENATE(COUNTIF($H$17:$I$50, "*SPO*")+COUNTIF($H$17:$I$50, "*Officer *"), " Enforcement Total") How do I make it come out with the count in red but the "Enforcement Total" be in black?
  13. N

    Using ConcatenateIf function trying to remove duplicates

    I have an excel sheet that has page numbers, Categories, and item numbers. I want to make almost an index of the Category then unique page numbers this is the code I am using now I need to find out were to add to remove the Dups. Function ConcatenateIf(CriteriaRange As Range, Condition As...
  14. Y

    Generate CODE using two cells

    I need to generate a CODE with the data from two cells for a project tracker, for instance: A1 = 24-10-2016, B1 = Adam Smith, My code in cell C1 should be "AS-1024", I have created this, But, If there are duplicate values in column C like, Consider Adam Smith and Aaron Swartz both got task on...
  15. D

    Concatenate excel keep number format from a forumula

    Hi Guys In cell C16 £1298 and in Cell B16 i have £1179 In cell B17 i have a simple formula =C16-B16 which obviously provide an answer £119 But i want it to say £119 More Expensive and keep the number formatting It is currently producing 119 More Expensive stripping the number format from...
  16. E

    changing display of a string

    Hi. I have the following in a cell that is a text. (D+0.0625)+(L+.125)+(D+0.625). I am able to substitute D with the the value 1 and L with the value 2 to give me (1+0.0625)+(2+.125)+(1+0.625). I would like to display it as1.0625x2.125x1.0625 the formula must add the values between the...
  17. E

    Concatenating NUMBERS only

    Hi Guys, I am stuck trying to concatenate 2 numbers cells, retaining the number format - is there anyway to do this or does excel always convert the concat to text? Example of what I am trying to do: In one column I have a mixture of 4 digit and 5 digit numbers. All of these need to be 5...
  18. D

    can you connatenate an offset command?

    I have a cell that looks up an account number and returns what row it is in. (B2) but, the data I am looking for is below and a few columns over, so I need to use an offset command to get the data. =OFFSET(data!F22,1,0) this works just fine. the problem is that I need to copy this command...
  19. S

    Concatenate a row or part of

    Hi all, I have been reading quite a few posts on this and haven’t managed to find what will work for me, - Several post talking about using VBA, but unfortunately as I’m sharing the document so this wouldn't be ideal (many won’t accept macros), - Several talking about a...
  20. C

    Vlookup tool with multi Criteria

    Hello All, I am Not a excel genius. I am trying to make a file in which i canauto fill information of employee on one single page. I have one file (Workbook 1)which has 52 tab (Each weekending Sunday). I want to make a formula in which if i put week ending and Employee number it gives me...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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