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
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
>
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.
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
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
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))
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
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
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 you
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
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) or
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
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,
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
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
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
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,
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
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
@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
)),
,)
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
]*
** **
*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
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.
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
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
.
** **
* *
*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
:
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
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,
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 =
-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
: *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
*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
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
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 : =A1
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
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
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
AND VBA MACROS excel-macros@googlegroups.com
*Sent:* Thu, December 17, 2009 8:32:23 AM
*Subject:* $$Excel-Macros$$ Concatenate after checking all cell
Date at sheet1Date at sheet2Date at sheet3Date at sheet4
Date at
sheet5Date at sheet6Concatenate(Final po Date)
0-Jan-000
-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
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
EXCEL AND VBA MACROS excel-macros@googlegroups.com
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(Final po Date)
0-Jan-00 0
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= ,
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
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
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
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
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.
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
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) .
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
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
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
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
53 matches
Mail list logo