Topic profile page for Concatenate.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Concatenate.
Topic "Concatenate" was discussed 8,422 times on 428 sites in last 3 months
Started 1 day, 5 hours ago (2009-12-01 08:57:00)
by Saintsman
How can I concatenate text in colB? ColA has 2 markers C and * Whenever C is followed by * I need to unite the text fields in ColB So, for the data below I want ColA ColB C Text1 Text1a C Text2 Text2a Text2b Text2c ColA ColB C Text1 * Text1a cont'd C Text2 * Text2a ...
Started 4 days, 4 hours ago (2009-11-28 09:20:00)
by Dr Paul
How can I concatenate several cells into a new cell, but in alphabetical order? PART 1 Example: Say I have a list of artists in cells A1 to E1 For instance A1 = "Queen" B1 = "Santana" C1 = "Kraftwerk" D1 = "Oasis" E1 = "Barry Manilow" Can I make a formula that fills cell F1 with the five artists from A1:E1, but in alphabetical order? ie the ...
Started 4 days, 17 hours ago (2009-11-27 20:30:00)
by Kilowoo
SUMIF from NAMES using CONCATENATE Hi All! I'm using Excel 2003, and Windows XP, anyway i think this might be an easy question. I have a good file where I pulled some figures ranged in names based on a concatenate data on other tab. I've used "names" for the different ranges of data. The cells c$2 to C$4 are "criterias" ...
Started 4 days, 20 hours ago (2009-11-27 17:06:00)
by jason_y
Hi, I was wondering if I concatenate strings within the query I write in a tag with dbtype="query"? I want to do something similar to the following: SELECT ('$ ' + TotalProfit) AS TotalProfit2 FROM SomecachedQuery I can do this if the query is run on the SQL server, but not with the cached query.If this is not possible, is there some ...
Started 6 days, 6 hours ago (2009-11-26 07:49:00)
by hardeep.kanwar
Mixture of Vlookup and Concatenate Hi! Experts I have Data Like Below, Its a Master Sheet On Daily Basis i have Received Around 100 Data. In which some Data is Already in Mentioned Below Data South Master Open Cases * A B C D E F G H I J K L M N 1 Call date Name Of The ...
Started 1 week ago (2009-11-25 10:45:00)
by subhas
Hi All. I have a macro to concatenate multiple cells but unfortunately it is not giving the result, It has to concatenate below mentioned cells and put the result in column N Here is the code Sub ConcatColumns() Do While ActiveCell "" 'Loops until the active cell is blank. 'The "&" must have a space on both sides or it will be 'treated as a variable ...
Started 1 week ago (2009-11-24 15:11:00)
by ladybirdwalker
CONCATENATE with spaces Hi Can some one please tell me if it is possible to concatenate with spaces? I have information (names) to pull from two cells into one but when i use CONCATENATE it adds both together and leaves no space. Am i using the wrong formula?
Started 1 week, 1 day ago (2009-11-23 21:28:00)
by phoenixaz
If I have an include file with... How can I concatenate to this sql statement... sql = "Select * from tablename" I tried all sorts of combinations and can't seem to get it to work. Thanks for your help.
Started 1 week ago (2009-11-25 08:44:00)
by Fernymike
I am using Access 2007 for an Aircraft History and would like help with the report The detail of the report has lines such as: First flight, Merlin C No. 11 , Watts Z2390, Brooklands, (pilot P. W. S. Bulman) 6-11-35. Second flight, Merlin C No. 11 , Watts Z2390, Brooklands, 11-11-35. Third flight, Merlin...
Started 1 week, 1 day ago (2009-11-24 11:26:00)
by Fire Raider
Please Register to Remove these Ads Hi All, Firstly i must appologise, i'm a complete newbie to excel and would appreciate any help possible. My task i believe is probably simple to the trained IT person unfortunately i'm not. I'm trying to get the text from a couple of cells concatenated into another cell depending on certain criteria. for ...
Started 1 week ago (2009-11-25 13:02:00)
by dodokh
A B C D E 1 AMM SSH CAI SSH AMM 2 3 AMM-SSH SSH-CAI CAI-SSH SSH-AMM How can we get A3:D3 automatically ? I tried concatenate function with "-" in between, but it does not help because if we delete AMM from E1 & SSH from D1 we still have (-).
Started 6 days, 23 hours ago (2009-11-25 14:09:00)
by dodokh
A B C D E 1 AMM SSH CAI SSH AMM 2 3 AMM-SSH SSH-CAI CAI-SSH SSH-AMM How can we get A3:D3 automatically ? I tried concatenate function with "-" in between, but it does not help because if we delete AMM from E1 we still have SSH- in D3 , so how can we get an empty cell in D3 ?
Started 1 day, 11 hours ago (2009-12-01 02:11:00)
by evelin via OfficeKB.com
hi friends i want to concatenate the value in cell A1 AND A2 AND PUT IN A1. SUPPOSE " string1" is a string variable EG. SUPPOSE A1 contains "office" and A2 contains "KB" , THEN variable string1=OfficeKB and assign to A1. THIS MUST BE DONE FOR A SET OV VALUES
Started 1 day, 11 hours ago (2009-12-01 02:06:00)
by evelin via OfficeKB.com
hi friends i want to concatenate the value in cell A1 AND A2 AND PUT IN A1. SUPPOSE " string1" is a string variable EG. SUPPOSE A1 contains "office" and A2 contains "KB" , THEN variable string1=OfficeKB and assign to A1. THIS MUST BE DONE FOR A SET OV VALUES
Started 2 days, 20 hours ago (2009-11-29 17:07:00)
by Hank Rearden
I'm trying to Concatenate a date and another field. I've searched two solutions that work, but they aren't in a format that will work. Here are the queries that work along with their outputs CAST( ProcessingDate AS CHARACTER(15)) + CostCenter AS 'PDCC' Nov 30 2009 12:001110 CONVERT(varchar(20), ProcessingDate) + CostCenter AS 'PDCC' Nov 30 2009 12:00AM1110 But the ...
Started 1 week, 1 day ago (2009-11-24 13:19:00)
by jmpuseer
Hi Guys, I am trying to concatenate similar name files from three different folders. I have folder_1 with three files called a.jmp, b.jmp and c.jmp. I have folder_2 with the same three file names. I have folder_3 with the same three file names. Now I want to concatenate a.jmp from folder_1 with a.jmp from folder_2 and a.jmp from folder_3. Similarly repeat this for b.jmp...
Started 2 days, 16 hours ago (2009-11-29 21:58:00)
by TKulak
I am supposed to have the first and last name of an individual go into my Input Box on a program I am working on. It is supposed to concatenate and then check to see if either the first or last name is longer than 10 characters using the LEN function then if so display a message box. I can't seem to get the LEN function coding right. Any ideas? This is my first problem that I am tackling!...
