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&B1&C1.
>
> On 23-Dec-2017 3:09 PM, "Aamir
If you have those values in A1,B1,C1. Then put formula in D1 as =A1&B1&C1.
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
> 148351,183776,032290
>
>
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.
>
> data
> 148351, 183776,
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
wrote:
> Hello,
>
> I
Dear Ashish Sir,
Thanks a lot.
Regards,
Prafull.
On Sat, Sep 14, 2013 at 8:59 AM, ashish koul wrote:
> you can write udf to concatenate the range
>
>
> On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav
> wrote:
>
>> Dear All,
>>
>> Can we concatenate by using range with Arrey formula.?
you can write udf to concatenate the range
On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav wrote:
> 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
> like concatenate
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 havin
Kaushik,
PFA, to see the formula.
On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA wrote:
> 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 20
> A3
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 title
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
Hi Kaushik,
Please check attached file.
On Tue, Jul 2, 2013 at 7:45 PM, KAUSHIK SAVLA wrote:
> 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 20
> A3
;
>> *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@goo
good
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:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Concatenate Problem.
Rajan,
100
;
> * *
>
> *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@googl
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 wrote:
Thanks..
Thanks
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 wrote:
> Ahmed ji..i think the file is alre
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 wrote:
> .
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, lik
catAll(rngRange As Range) As String
>>
>> ConcatAll =
>> *Join*(Application.Transpose(Application.Transpose(rngRange)),
>> ",")
>>
>> End Function
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>
o:
> 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 & Regard
:55
To: excel-macros@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
wrote:
See attached sheet.
On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI
wrote:
Thanks .very
Thanks & Regards,
*Deba Ranjan P*
On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote:
> See attached sheet.
>
>
> On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Deba,
>>
>> Please try below UDF, See attached sheet..
>>
>> *Function Concatenat
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
w
Awesome, thanks
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Wed, 29 Feb 2012 08:38:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Concatenate help
*Try it:*
=TEXT(A1,".?")&a
macros@googlegroups.com
> *Date: *Wed, 29 Feb 2012 01:04:59 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Concatenate help
>
> Hi Joseph,
>
>
> use concatenate with text formula
>
> =CONCATENATE(A2," "
Thank your for a prompt reply.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: xlstime
Sender: excel-macros@googlegroups.com
Date: Wed, 29 Feb 2012 01:04:59
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Concatenate help
Hi Joseph,
use
Hi Joseph,
use concatenate with text formula
=CONCATENATE(A2," ",TEXT(A3,"0.00%"))
On Wed, Feb 29, 2012 at 1:01 AM, 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 = 10.534809
> Cell
Dear Maureeze,
Solution of your Problem is :
1. A1=concatenate("A",text("1","1"))
2. A1="A"&TEXT("1","1")
Thanks & regards,
Noorain Ansari
On Wed, Sep 22, 2010 at 6:03 PM, Maureeze wrote:
> Dear all,
>
> I have been looking for a solution for this problem for a while and i
>
Hi
Use indirect function
=INDIRECT("A"&1)
I hope it helps.
regards,
Ayush
On Wed, Sep 22, 2010 at 6:03 PM, Maureeze 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 following :
-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 s
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 wrote:
> Dear paul Thanks
Dear paul Thanks For reply.
I know concatenation
=CONCATENATE(B2,C2,D2,E2,F2,G2)
=(B2&""&C2&""&D2&""&E2&""&F2&""&G2)
Will not give the suitable result
As i have already tried.Prblem is that 6 person enter the data for same
client and
now i have to concatenate these report.
As i mension in the ex
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
s would 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 w
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),
Hi Steve,
If you use the suggested =B4 & " " &C4 & " " & D4 etc, the result will be
double spaces for each blank cell.
You can get rid of these using the TRIM function.
=TRIM(B4 & " " &C4 & " " & D4)
Regards = Dave
On Nov 23, 3:22 am, Shujaat Ali wrote:
> Try this
>
> =B4 & " " &C4 & " " & 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 a
> 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+Ent
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) .
attached herewith the solution of your question.
Regards,
Lavprasad
On Mon, Nov 23, 2009 at 2:31 PM, Steve 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 spaces and r
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 wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use
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 wrote:
>
> I am try
HI Steve,
You can insert a blank space ( as long as you want ) in a cell & include that
cell in your concatenate formula every time you need space in between.
The cell will be visible as empty one but it will be having a space in it.
ANURAG SINGH ASWAL
This Communication is Confidential. We
Try this
=B4 & " " &C4 & " " & 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 wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use the con
43 matches
Mail list logo
