Re: $$Excel-Macros$$ concatenate in one cell

​this formula is already applied, but I want to enter formula automatically because i have data from A1 to HA1 and get data into B1 On Sat, Dec 23, 2017 at 6:57 PM, Prabhu Pinky wrote: > If you have those values in A1,B1,C1. Then put formula in D1 as =A1 > > On

Re: $$Excel-Macros$$ concatenate in one cell

If you have those values in A1,B1,C1. Then put formula in D1 as =A1 On 23-Dec-2017 3:09 PM, "Aamir Shahzad" wrote: > Friends, > > I want to concatenate all below data in one cell without any space. > Formula please. > > data > 148351, 183776, 032290, > > result >

Re: $$Excel-Macros$$ concatenate in one cell

If I understand correctly, you need the excel data in a csv format. If that is the case save the file as .csv file. On Saturday, December 23, 2017, Aamir Shahzad wrote: > Friends, > > I want to concatenate all below data in one cell without any space. > Formula please.

Re: $$Excel-Macros$$ Concatenate with VBA

hi check this.. http://stackoverflow.com/questions/22382416/in-excel-2010-how-could-i-remove-duplicates-and-concatenate-values-within-a-cel Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 2, 2014 at 3:02 PM, Mandeep Baluja rockerna...@gmail.com

Re: $$Excel-Macros$$ Concatenate.

Dear Ashish Sir, Thanks a lot. Regards, Prafull. On Sat, Sep 14, 2013 at 8:59 AM, ashish koul koul.ash...@gmail.com wrote: you can write udf to concatenate the range On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Can we concatenate by

Re: $$Excel-Macros$$ Concatenate.

you can write udf to concatenate the range On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Can we concatenate by using range with Arrey formula.? for example From Range(A2:K2) ..i have to concatenate.. but for this i have to put formula

Re: $$Excel-Macros$$ Concatenate range of cells in excel

Hi Kaushik, Please check attached file. On Tue, Jul 2, 2013 at 7:45 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Team, I am having some data in Cell A1 to A100 and I want to concatenate range of data from A1 to A100 with comma as seperator. Example: Cells A1 10 A2

Re: $$Excel-Macros$$ Concatenate range of cells in excel

Kaushik: As your values are in Cells A1 to A2 write in Cell B1 formula =A1 and in cell B2 = concatenate(B1,,,B2) and now this cell B2 formula copy and paste from cell B3 to B100 then finally the result you are looking for will be in B100. Hope this helps On Tue, Jul 2, 2013 at 5:15 PM,

Re: $$Excel-Macros$$ Concatenate range of cells in excel

Thanks Vijay and Ahmed to resolve the query. Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Concatenate range of cells in excel

Kaushik, PFA, to see the formula. ​ On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Team, I am having some data in Cell A1 to A100 and I want to concatenate range of data from A1 to A100 with comma as seperator. Example: Cells A1 10 A2

Re: $$Excel-Macros$$ Concatenate range of cells in excel

We can use this in VBA Module Function ConcatRange(Rng As Range) Dim i As Range For Each i In Rng ConcatRange = IIf(IsEmpty(ConcatRange), i.Value, ConcatRange , i.Value) Next End Function Rgds, [dp] Pada 02/07/2013 21:15, KAUSHIK SAVLA menulis: Hi Team, I am having

Re: $$Excel-Macros$$ Concatenate Problem.

Dear Deba, Please try below UDF, See attached sheet.. *Function Concatenate_Deba(rng As Range) Dim cell As Range Dim str As String For Each cell In rng str = str cell , Next cell str = VBA.Right(str, Len(str) - 1) Concatenate_Deba = str End Function * -- Thanks regards, Noorain Ansari

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks .very Thanks Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: See attached sheet. On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Deba, Please try below UDF, See

RE: $$Excel-Macros$$ Concatenate Problem.

@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate Problem. Thanks .very Thanks Regards, Deba Ranjan P On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: See attached sheet. On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI noorain.ans

Re: $$Excel-Macros$$ Concatenate Problem.

)), ,) End Function * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan *Sent:* 11 June 2012 5:55 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros

Re: $$Excel-Macros$$ Concatenate Problem.

]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan *Sent:* 11 June 2012 5:55 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Concatenate Problem. ** ** Thanks .very Thanks

Re: $$Excel-Macros$$ Concatenate Problem.

Ahmed ji..i think the file is already attached in this group. Thanks Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest ahmedhon...@gmail.com wrote: . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Concatenate Problem.

Dear -- I deleted the email when i read it for the first time, thinking this will be easily answered by the group. Anyways see attach i have created an example of your file which you sent. Thanks, On Mon, Jun 11, 2012 at 3:57 PM, Deba Ranjan drdeva...@gmail.com wrote: Ahmed ji..i

RE: $$Excel-Macros$$ Concatenate Problem.

Subject: Re: $$Excel-Macros$$ Concatenate Problem. Hi Deba, the same can be achieved without VBA let me know if you wish to have that. Just send me your file. I will send you the solution. On Mon, Jun 11, 2012 at 3:54 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks

Re: $$Excel-Macros$$ Concatenate Problem.

. ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest *Sent:* 11 June 2012 6:26 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Concatenate Problem

Re: $$Excel-Macros$$ Concatenate Problem.

: excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest *Sent:* 11 June 2012 6:26 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Concatenate Problem. ** ** Hi Deba, the same can be achieved without VBA let me know if you wish to have that. Just

Re: $$Excel-Macros$$ Concatenate help

Hi Joseph, use concatenate with text formula =CONCATENATE(A2, ,TEXT(A3,0.00%)) On Wed, Feb 29, 2012 at 1:01 AM, joseph.cam...@gmail.com wrote: Hi guys, I am trying to concatenate two cells. One cell ha absolute number whereas the other cell is a percentage. For e.g., Cell A1 =

Re: $$Excel-Macros$$ Concatenate help

Thank your for a prompt reply. Sent on my BlackBerry® from Vodafone -Original Message- From: xlstime xlst...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 29 Feb 2012 01:04:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ Concatenate help

: *Wed, 29 Feb 2012 01:04:59 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Concatenate help Hi Joseph, use concatenate with text formula =CONCATENATE(A2, ,TEXT(A3,0.00%)) On Wed, Feb 29, 2012 at 1:01 AM, joseph.cam

Re: $$Excel-Macros$$ Concatenate help

*Date: *Wed, 29 Feb 2012 01:04:59 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Concatenate help Hi Joseph, use concatenate with text formula =CONCATENATE(A2, ,TEXT(A3,0.00%)) On Wed, Feb 29, 2012 at 1:01 AM

Re: $$Excel-Macros$$ Concatenate

Hi Use indirect function =INDIRECT(A1) I hope it helps. regards, Ayush On Wed, Sep 22, 2010 at 6:03 PM, Maureeze maure...@gmail.com wrote: Dear all, I have been looking for a solution for this problem for a while and i hope that someone out there can help me. How do i exececute the

Re: $$Excel-Macros$$ Concatenate

Dear Maureeze, Solution of your Problem is : 1. A1=concatenate(A,text(1,1)) 2. A1=ATEXT(1,1) Thanks regards, Noorain Ansari On Wed, Sep 22, 2010 at 6:03 PM, Maureeze maure...@gmail.com wrote: Dear all, I have been looking for a solution for this problem for a while and i

Re: $$Excel-Macros$$ Concatenate after checking all cell

TEXT(IF(ISTEXT(B41)=FALSE,B41,IF(ISTEXT(C41)=FALSE,C41,IF(ISTEXT(D41)=FALSE,DC41,IF(ISTEXT(E41)=FALSE,E41,IF(ISTEXT(F41)=FALSE,F41,IF(ISTEXT(G41)=FALSE,G41,)),DD-MMM-) try this see whether it works for you o On Fri, Dec 18, 2009 at 10:51 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote:

RE: $$Excel-Macros$$ Concatenate after checking all cell

-Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of shyam Sent: Thursday, December 17, 2009 7:02 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Concatenate after checking all cell Date at sheet1 Date at sheet2 Date at

Re: $$Excel-Macros$$ Concatenate after checking all cell

Not sure of your meaning.. concatenate means to join two strings end-to-end. so, your first line becomes: 0-Jan-000-Jan-000-Jan-0029-Nov-080-Jan-000-Jan-00 THAT is the meaning of concatenation. At first glance, it looks like you're trying to find the maximum (or latest) date. However, in your

Re: $$Excel-Macros$$ Concatenate, including blank fields

Out of interest what was wrong with Koul's 'concatenate' example with nested IF's ... ? This is the route I would have gone, although I would update it slightly like so ... =CONCATENATE(IF(OR(ISBLANK(A1), A1= , A1= ), ,A1),IF(OR(ISBLANK(B1), B1= , B1= ), ,B1),IF(OR(ISBLANK(C1), C1= ,

RE: $$Excel-Macros$$ Concatenate, including blank fields

be concatinated without spaces. Also, the formula is really long. Regards - Dave. From: lukethegoo...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate, including blank fields Date: Tue, 24 Nov 2009 10:19:37 + Out of interest what was wrong with Koul's

Re: $$Excel-Macros$$ Concatenate, including blank fields

Try this =B4C4 D4 = will put a space, whether the cells are blank or filled. hope it helped. On Mon, Nov 23, 2009 at 12:01 PM, Steve sca...@aol.com wrote: I am trying to concatenate 8 columns, all of which containe either a single character or a blank. When I use the

Re: $$Excel-Macros$$ Concatenate, including blank fields

hi CONCATENATE(IF(ISBLANK(A1), ,A1),IF(ISBLANK(B1), ,B1),IF(ISBLANK(C1), ,C1),IF(ISBLANK(D1), ,D1),IF(ISBLANK(E1), ,E1),IF(ISBLANK(F1), ,F1),IF(ISBLANK(G1), ,G1),IF(ISBLANK(H1), ,H1) also attached in workbook On Mon, Nov 23, 2009 at 2:31 PM, Steve sca...@aol.com wrote: I am trying

Re: $$Excel-Macros$$ Concatenate, including blank fields

Hi, The answer is in your questions only. Just put space in blank field. I hope you got what I am trying to say. Regards, Swapnil. On Mon, Nov 23, 2009 at 2:31 PM, Steve sca...@aol.com wrote: I am trying to concatenate 8 columns, all of which containe either a single character or a blank.

Re: $$Excel-Macros$$ Concatenate, including blank fields

attached herewith the solution of your question. Regards, Lavprasad On Mon, Nov 23, 2009 at 2:31 PM, Steve sca...@aol.com wrote: I am trying to concatenate 8 columns, all of which containe either a single character or a blank. When I use the concatenate funciton it leaves out the blank

Re: $$Excel-Macros$$ Concatenate, including blank fields

Dear Steve, you can fill all the balnks with space. in order to do the same 1. select your range 2. press F5, 3. then clicke on special button 4. select blanks 5. press ok. this will select all the balnk cell in the range. then fill those balnk with space (all together by pressing ALTt+Enter) .

Re: $$Excel-Macros$$ Concatenate, including blank fields

you can fill all the balnks with space. in order to do the same 1. select your range 2. press F5, 3. then clicke on special button 4. select blanks 5. press ok. this will select all the balnk cell in the range. then fill those balnk with space (all together by pressing ALTt+Enter) . I

Re: $$Excel-Macros$$ Concatenate, including blank fields

On Nov 23, 3:22 am, Shujaat Ali shujaa...@gmail.com wrote: Try this =B4C4  D4 = will put a space, whether the cells are blank or filled. It's not the same column that's blank each time so you never know where the space is going to be. I think I found the problem, there's not