concatenate

Hello! This is my first post on Mr Excel :) I am trying to collate a list of numbers so they have an exclamation mark at the start and a semi-colon at the end. I wish for these to all end up in one cell so I can copy and paste them into a business intelligence system that requires this format...

Hi I have Key & sheet names in Sheet1 & key(with Concatenate) need to vlookup with Key in another sheets & get the Sheet Name & sum the column values.

I have data in Column A1:A100 and B1:B100. I need to Concatenate data in C column so that column A data appears below column B data in respective cell.

Hi Everyone, I've been developing a project for work that will analyse bank accounts to determine the value of a project. The problem is some of our projects have inter-account transactions. In order to determine the proper worth of the project we have to find any transfers between the...

I have a list that I need to remove the zero value items from via formula to create a new list (imagine an order form). Because people will be using this second form without much excel knowledge, I need it 100% formula driven. <colgroup><col><col><col></colgroup><tbody> Qty Item Estimate...

Hi MrExcel World, I am trying to concatenate 2 cells, which is easy enough. The problem I am having is that one if one of the cells is blank I don't want to return anything. Example below; Concatenate----------------------First Name----Last Name John...

I'm trying to write a VBA that will concatenate the same cell across a whole folder of workbooks. Each workbook in the file is the same, just a different topic. I have 15 different workbooks, for example I have Lion, Tiger, and Panther. In sheet 3 column D of each of these books I have some...

I am trying to concatenate unique column text into a single cell. After spending an afternoon researching, I can now concatenate all the text in different column cells and remove duplicates. However, if one of these cells is empty, I get a blank value. as an example, I want to concatenate all...

I have 2 columns (K and L) with the dates in the format: 08/27/2019 & 08/29/2019. I want to use a Concatenate formula to have the end result showing: Aug 27 - Aug 29. The formula I wrote is as follows: =CONCATENATE(TEXT(K3,"[$-409]mmm d;@")," - ",(TEXT(L3,"[$-409]mmm d;@"))) However this...

Hi there, I am trying to concatenate different columns from 2 sheets, which are in different order one to each other. This would be the columns i need from the Auto sheet, and their counter from Manual sheet: <tbody> Auto Manual Column Column Q AB S T T U U AN V V W AQ X AT...

I have the following column values Input Account no Code 000005678 ABC 000005678 EDF 000001234 ABC 000001234 ABC Desired Output Account no Code 000005678 ABC 000005678 EDF 000001234 ABC Criteria Concatenate Column A and B (i.e...

I have a sheet as below with several dozen columns and thousands of rows. I want to join each column separtated by a / and a space. They are set out like below but if i do a normal concatenate formula I could end up with row 2 something like 8E0145806Q/ / / / / /. Row 4 is what how I would like...

Currently I am trying to figure out why Query is changing the information and pulling on cells it shouldn't be? I have a table setup which is this: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 100px"><col...

I use concatenate to create a code so I can use vlookup. The source of data comes from 2 separate sheets. The issue is I get two different result using concatenate (i.e. formula = concatenate (A1,B1) which is the date,client's surname. The two different results from the two sheets are...

I want to concatenate 2 $ amounts but I lose the $ and the , in between the numbers. For example: A1 = $100,000 B1 = $200,000 C1 = concatenate (a1," & ",B1) The result I get is 100000 & 200000 So I lose the $ and the commas. Any suggestions? thanks

concatenate if cells (col) is not blank anyone can help me :) <tbody> H K L (Result) ABC no result due to K is blank. Formula here ABC D ABCD </tbody>

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

Failing at every turn to get the correct formula. IF cell P1 contains the word Delivery concatenate 3 cells together. This I have been able to do. but adding If Cell P1 is equal to Pickup then merge these 3 cells. When it says Delivery im good but otherwise I will get a False return instead...

Hello, I have a spreadsheet that is concatenating multiple ranges of data to formula a note that can be copied and pasted elsewhere. Unfortunately I can't figure out how to exclude blank cells and instead I'm getting 0's in my final note, like this: <tbody> #D9D9D9[/URL] , colspan: 2"]...

Dear All, I do have the sample data set across A1:C6. I would like to concatenate as follows:- <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Region Store Result East a East b East c a-b-c West d West e d-e...