concatenate formula

  1. S

    Issues with a formula - Results no correct

    So I have a sheet where I have some dates and some results, I am trying to combine a few different formulas into a single one so that I don't have to look at several columns to get my results. When I have the formulas separated, it works fine, but when I try to combine them, I don't get the...
  2. M

    Logic Test Comparing Names in a List

    I have a cost spreadsheet that pulls from a database. We have trouble with accounting not setting the employees rate or classification correctly. I am trying to make a logic test that would check a concatenation of the user name, classification, and rate against a master list set up for the...
  3. C

    How to add dollar signs and commas to the CONCATENATE formula

    I am using the following formulas, but I cannot figure out how to get my result to include a dollar sign and commas to appear as currency. Can someone show me where I need to put edits? =CONCATENATE("You want to make $",ROUND($D$7/($D$8/12),0), " per year?") Currently producing: You want to...
  4. HackSlash

    Help cleaning up formula that concatinates two cell values based on a partial string match

    I'm not very confident with formulas. I made something really ugly and then thought "There must be a better way". I will first tell you what I want: I need to search for a partial string match on a cell in a known range on a different sheet. Once the match is found I need to take the cell...
  5. J

    Update source location of linked data using string in formula & values worksheet

    First thread, please help! I have a massive workbook that I have linked with several other workbooks on a network drive. I have the following formula: ='M:\Financial Aid\John''s Stuff\Win-Loss\[Grids 16-17.xlsx]NEW (FR&TR)'!$D7 This allows me to pull data from that spreadsheet into my current...
  6. B

    CONCAT or INDIRECT not working for dynamic formula

    Hello, I have used the INDIRECT in a bunch of workbooks to dynamically create formulas based on 1 or multiple cells. Usually to reference a worksheet tab name based on date or function. A3 = 10012015 (cell formatted as text as I need leading zeros) E.g...
  7. R

    Combine information from many columns into one but skip if blank and insert commas

    Have 6 columns of data (like below but some columns could be blank or even all) and then a column that will summarize the preceding information such as the examples below: <colgroup><col width="87" span="7" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> AG1 MSC1 MG1 SR1...
  8. T

    Concatenate to get formula

    Hello All! Does anybody know to concatenate texts and values from different cells to get a valid working formula? To illustrate: Let's presume I have cells with values "Sheet2", "!", "B", and "2". How can I concatenate these to behave as if it were a formula =Sheet2!B2 to get data from cell B2...
  9. S

    Concatenate data from mutiple cells only if they contain certain values

    Hi Gurus, I'm new to this community/forum and I am hoping you can help me with the most easiest and efficient way (Formula or VB code) to get an excel spreadsheet to Concatenate data from mutiple cells only if those individual contain certain values as shown in the example table below. Example...
  10. F


    hi, how to write CONCATENATE function to connect 3 fields (AM, AN, AO). For i = 5 To x_ws1_rows ws1.Range("AK" & i).Value = ws1.Range("AG" & i).Value day1 = Day(ws1.Range("AK" & i).Value) ws1.Range("AM" & i).Value = day1 month1 =...
  11. M

    Concatenate & SUMIF Formatting

    Using Excel 2013 on Windows 8 laptop... not sure what else you need. I've managed (I don't know how) to create this really cool formula in my file I use for my checkbook register to tell me the total balance that's cleared... but the formatting is wrong - and it's irritating me greatly! Any...
  12. K

    How to concatenate multiple columns/rows based on criteria?

    Hello, I am new to this forum. In the past I have found extremely helpful information. I have a dilemma with a project that I can currently working on that I desperately need assistance on. Issue: I have data that has been broken up into multiple cells; sometimes into multiple consecutive...
  13. S

    How to combine multiple columns of vlookups results into 1 cell

    Hopefully the title isn't too confusing. Basically we are combining MPN's from our competitors for an upload to a repricer website. I have 3+ columns of vlookup results and would like for them to be combined like this (blahblah,blahblah,blahblah) while leaving out the cells with no results. I...
  14. A

    Improve existing VBA loop to clean SAP output for MS Access

    So, I get an SAP output from a SPOOL. It comes out as a terrible "|" delimitated .CSV file in multiple "pages" which are actually blank rows with "---------" in between and some other text. I have to clean it before importing it in to Access which I have a VBA script for. I have this code to do...
  15. M

    Help with Concatence and Pivot Tables

    Good Afternoon Excel Guru's, I have moderate excel skills (more like pretty good at Google searching) and I am new to concatenate and I believe this is the best function to use. Monthly I will be pulling reports from a website and exporting to CSV from there it gets (VBA) imported to my...
  16. B

    Concatenate Lists of Different Lengths

    Hi All, I have three lists: Column A: 50 state names Column B: List of types of autos (private passenger, light, medium, heavy, extra-heavy) Column C: List of numbers (100, 200, 300, 400, 500, 600, 700, 800, 900, 1000). I want to concatenate the three lists together to create unique...
  17. E

    Sum results of concatenate formula

    I can’t for the life of me figure this out; neither on my own nor through hours of googling. Here’s the deal:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a column of numbers I want to sum (or sumif.) These numbers are the result of...
  18. N

    Concatenate location- Vlookup

    Hi everybody, I am in search of some help..again:) I want to use a vlookup function that concatenates actual storage location, file name and tab name. Can you let me know how I should structure the vlookup function so that it automatically uses cell information and performs the lookup...
  19. M

    Please help! Concatenate function stringing more cells together than in formula

    Hi there! I'm using the concatenate function. When I put in this formula =CONCATENATE(B1, " ", C1) where B1 is a geographical location, " " is space, and C1 is keyword. When I hit Return, it seems to string together ALL of the keywords together after B1. I'm completely stumped and I'd...
  20. R


    I'm trying to use the concatenate formula but it keeps returning a "#value" error. My formula is as follows: =concatenate("K",c12,d7,e9). c12=902, d7=E, e9=1. So concatenate should return K902E1. Any advice?

Some videos you may like

This Week's Hot Topics