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,
Friends,
I want to concatenate all below data in one cell without any space. Formula
please.
data
148351, 183776, 032290,
result
148351,183776,032290
Regards,
Aamir Shahzad
--
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 Faceb
Hi All,
Please suggest how to concatenate with bold in excel.
Like Ram Mohan I want Ram with bold formatting
--
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
F
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
Hello,
I need your help to acheive something with the help of regular expression
or by any way in vba. what i want is to concateneate a range of cells if
its cell is having duplicates then it should be concatenate only one time.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
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
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(A2,B2,C2,D2...)
Can we do this by using Range.
concatenate(Range("A2:K2")
Regards,
Prafull Jadhav.
--
Are yo
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
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 30
&so on
I want result as 10, 20, 30 & so on.
Please help.
Warm Regards,
Kaushik Savla
--
Are you =EXP(E:RT) o
;
>> *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
Dear experts,
Please find the attached file. There is 568 names listed in A2,
I want the whole names should come in one single cell with comma.
Please..
Thanks & Regards,
*Deba Ranjan P*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, ac
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
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 A2 = 18.5648%
The output should be:
Cell A3 = 10.5 18.5%
But my output with Concatenate formula is 10.534809 0.185648
Please help.
Best,
Jos
Dear Group Friends,
I have two work sheet. Sheet1 contain bill number in column B, and
sheet2 contain bill number and PRA No in column A and column B.
My problem is, I want to concatenate the PRA No. with "," for every
unique bill Number.
e.g. Sheet1 date are as Under:
Bill No.
FDN/01
FDN/02
FD
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 :
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 : =A&1
I want A and 1 joined together and then execute that as =A1 and show
me the value of what is in A1
Thank you,
ps : This is an simpl
-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
nd TIME? is really just the fractional part of a day.
>> 39781.3706712963 is November 29, 2008 at 8:53:46AM)
>>
>> The reason that this is important is that if you want to find
>> the most recent date, you really just need to look for the
>> largest number.
>>
>> t
number.
>
> try: =MAX(A2:G2) in row 2 and copy it down.
> be sure to change the cell formatting to Date format.
>
> Is this what you were trying to do?
>
> Paul
> --
> *From:* shyam
> *To:* MS EXCEL AND VBA MACROS
> *Sent:* Thu, Dec
___
From: shyam
To: MS EXCEL AND VBA MACROS
Sent: Thu, December 17, 2009 8:32:23 AM
Subject: $$Excel-Macros$$ Concatenate after checking all cell
Date at sheet1 Date at sheet2 Date at sheet3 Date at sheet4 Date at
sheet5 Date at sheet6 Concatenate(Fina
Date at sheet1 Date at sheet2 Date at sheet3 Date at sheet4 Date at
sheet5 Date at sheet6 Concatenate(Final po Date)
0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan-00
0-Jan-0029-Nov-08
0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan
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
. We only send and receive email on the basis
of the term set out at www.ericsson.com/email_disclaimer
-Original Message-
From: Steve [mailto:sca...@aol.com]
Sent: Monday, November 23, 2009 2:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Concatenate, including blank fields
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
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 runs all the letters together (without
spaces). Is there a way that a blank cell can be concatenated as a
blank space? Can I
I have a 1400 row .csv file of emails.
A1 : abc...@hotmail.com
B1 : def...@yahoo.com
C1: ghi...@gmail.com
etc...
How would I go about concatenating the emails and separating them with
commas so I recieve:
abc...@hotmail.com,def...@yahoo.com,ghi...@gmail.com ETC
I am a rookie with hardcore
Hi,
I could really use some help with creating a macro. I have two
columns of data. The first column provides me with a list of Part
Numbers and the second column Provides the Description of the Part
Numbers. There are multiple rows for the Descriptions because that's
the way they come into my
How to concatenate the below one.
A1=India
B1=Bangalore
C1=12:10Am
Thanks in advance.
Vinu.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.c
Hi All,
I have an issue while using concatenate formula, Can any one of you help me
out with this:
Query:
Column A : MS
Column B : Excel
Column C : 24- Oct-08 ( formated as d-mmm-yy).
When I use concatenate i get a result as : MS Excel 39745
After formatting the cell too d-mmm-yy, I get the sa
58 matches
Mail list logo
