concatenate cells

to all Is there a way of checking when the 1st cell in a range is used see below Sub macro1() Dim rgcurrentrw As Range Set rgcurrentrw = ActiveSheet.Range("A2:E2") Dim strout As String 'what I have currently For Each cell In rgcurrentrw strout = strout & "," & cell.Value Next cell...

Hi, I would like to know if it possible to concatenate multiple cells in aa column (selction will vary - sometimes 3, sometimes 5) and place the concatenated value with delimiter "space" in the selected range top cell if A1:A3 is my range Result A1 = A1&" "&A@&" "&A3 if A1:A5 is my range...

Hi, i have a problem with my sheet. First of all sorry for my bad english. I want to concatenate text with spaces and to ignore blank cells. I have a formula =IF(B2="";"";B2)&IF(C2="";"";" "&C2)&IF(D2="";"";" "&D2)&IF(E2="";"";" "&E2)&IF(F2="";"";" "&F2)&IF(G2="";"";" "&G2), but it doesn't work...

I want to concatenate 2 columns so that text appears after a date and the date formatting does not change. When I do, the new column converts that date to text and generates a new text "44224-text". Is there a way to display the "date-text" while maintaining the date formatting? example...

Hi , I need to concatenate Row C value with its last cell value one another one in a below format and paste the output in Row D. Multiple files I have, so the number of rows will increase for each workbook. For Eg: C D 001 0001 OF 0005 002 0002 OF 0005 003...

Hi Everyone! Hope I throw an easy one this time. First post. I am trying to concatenate 2 excel cells that have some text strings in them. I tried all the possible variants that I found in the internet before posting this and are the following: 1. =concatenate(C3,' ',D3) 2. =C3&," ",&D3 To...

I am trying to pull data from to cells in a worksheet to name the tab of a new work sheet. I can make it work for data in one cell but not the two. Here is what i am using for the one ActiveSheet.Name = Sheets(2).Range("A3").Offset(counter - 1, 0).Value 'name sheet I would also like to...

My formula is =concatenate(A15,B15,C15) which I enter directly by typing "A15" "B15" etc. I would like to create a concatenate that picks up the row number from another cell. Is this possible? This is clumsy but it is the only way I can conjure how to explain: Desired =concatenate(A(go get the...

I am trying to make an equation that reformats international phone numbers. For instance, if this is the input: +44(0)1111111111, I would like to make an equation to remove the "+", remove the "(0)" and add "011" as a prefix to the number. For example +44(0)1111111111 would become...

Hello, I'm trying to concatenate a few cells so I can use the string in a word document without retyping numbers. Could someone show me how to keep the conditional format of accounting format numbers in the concate results? <tbody> Day Net Amt Currency RATE Interest 3...

Can somebody help me to solve the below problem using VBA? I want to concatenate cells A7, A8, B8, A9 and paste it to A7. Similarly concatenate A10, A11, A12, C12, A13, A14 and paste to A10. Concatenate A15, A16 and paste to A15. Keep A6 same and A17 same as original value. Any help is...

I have a requirement that involves a list of Personnel numbers copied into a spreadsheet that need to be transposed. They must be separated by a comma and concatenated into one cell so that they can be copied and pasted into a cell in a database. Unfortunately, this list could be just a handful...

Hi there, I am wondering how to combined multiple cells, in 2 columns into one. IE: Last Name First Name Full Name Smith John Smith, John Shepherd Matt Shepherd, Matt .... .... .... I used the Concatenate(A2:B2)...

I'm trying to write a macro to concatenate five columns of information (Columns A - F) into Column G. Everything in Column A starts with either ABC, DEF, or GHI, and I'd like the macro to skip Column E for rows where Column A starts with DEF. So if Column A starts with ABC or GHI, concatenate...

Hello, I want to concatenate all words with a space in the same row but some rows has more than 30 columns How can I make simple this formula maybe with function? =CONCATENATE(A1," ",B1," ",C1," "......... until there is text in the cell? Thanks in advance :)

Hi, I am trying to concatenate value of cell A1 and Value of cell B1 and "-" between them. I am trying this: ActiveCell.Formula = "=CONCATENATE(A2,"-",B2)" But no luck. Please help

Hi, I need a help in developing a macro. I have a example. I have 4 columns. first 3 columns ID, C1, C2 have the input data. Under a ID we have multiple number of rows. In this example we have 4 rows for ID1. But in real time it can be any number of rows under a single ID. When I click a...

Hi everyone. I'm trying to concatenate a few cells but seem to be missing the mark with my code. Can you show me where I went wrong. Thank you Dim counter As Long Dim b As Range Dim e As Range Dim g As Range Range("E1").Select 'Set the range for the loop...

I am trying to join text in two different cells using concatenate function / & operator In the combined cell I want the text from second cell to appear in Bold while the text from first cell should continue to remain in normal font. Is there any way i could achieve this?

How to concatenate FIRST SECOND & THIRD name in a single cell separated by a blank. A1: Mark B1: Hu. C1=England Answer: D1: Mark Hu. England