concatenate formula

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?