On Mon, 1/1/18, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Monday, January 1, 201
On Sun, 12/31/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Sunday, December 31, 2017
On Sun, 12/31/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Sunday, December 31, 201
On Sun, 12/31/17, 'Martinez David' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Sunday, December 31, 201
On Sat, 12/30/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Saturday, December 30, 2017
On Sat, 12/30/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Saturday, December 30, 2017
On Fri, 12/29/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Friday, December 29, 201
On Thu, 12/28/17, N.Shivkumar wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Thursday, December 28, 2017, 8:14 AM
see attached solution
On 25
see attached solution
On 25 December 2017 at 14:35, Aamir Shahzad
wrote:
> this is manual formula & need select cells one by one I want to use entire
> range e.g. A1:HL1
>
> On Mon, Dec 25, 2017 at 4:40 AM, who wrote:
>
>> =trim(C4)&trim(D4)&trim(E4)&trim(F4)&trim(G4)
>>
>> Try the abo
On Tue, 12/26/17, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Tuesday, December 26, 201
On Mon, 12/25/17, Aamir Shahzad wrote:
Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
To: excel-macros@googlegroups.com
Date: Monday, December 25, 2017, 11:05 AM
this is manual formula &
need select cells one by one I want to
But this will work, but you need select each cell manually. Thanks, David
=TRIM(CONCATENATE(A2,B2,C2))
On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>
> Friends,
>
> I want to concatenate all below data in one cell without any space.
> Formula please.
>
> data
> 148351
I can not think of another way. Good luck, David
On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, 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
>
this is manual formula & need select cells one by one I want to use entire
range e.g. A1:HL1
On Mon, Dec 25, 2017 at 4:40 AM, who wrote:
> =trim(C4)&trim(D4)&trim(E4)&trim(F4)&trim(G4)
>
> Try the above, assuming the data is in the addresses used.
>
> Thanks, David
>
> On Saturday, December 23,
=trim(C4)&trim(D4)&trim(E4)&trim(F4)&trim(G4)
Try the above, assuming the data is in the addresses used.
Thanks, David
On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>
> Friends,
>
> I want to concatenate all below data in one cell without any space.
> Formula please.
As I couldn't got the answer so far so please resolve the attached query.
On Sun, Dec 24, 2017 at 4:57 AM, who wrote:
> Use the Trim function. Thanks, David
>
> On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>>
>> Friends,
>>
>> I want to concatenate all below data in o
Use the Trim function. Thanks, David
On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, 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
>
> Regards,
cheers buddy!!
It will help you most...
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 2, 2014 at 3:33 PM, Mandeep Baluja
wrote:
> Thanks Vabz
>
> On Tuesday, December 2, 2014 3:02:29 PM UTC+5:30, Mandeep Baluja wrote:
>>
>> Hello,
>>
>> I need your help
Thanks Vabz
On Tuesday, December 2, 2014 3:02:29 PM UTC+5:30, Mandeep Baluja wrote:
>
> 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
lack > > wrote:
>
> >> Hi Manish,
> >> Please attach the solution you have. Perhaps one of us may be able to
> >> speed it up.
> >> Regards - Dave
>
> >> > Date: Tue, 18 Jan 2011 23:24:56 -0800
> >> > Subject: Re: $$Excel-Mac
umar
>
>
> On Wed, Jan 19, 2011 at 2:16 PM, Dave Bonallack > wrote:
>
>> Hi Manish,
>> Please attach the solution you have. Perhaps one of us may be able to
>> speed it up.
>> Regards - Dave
>>
>>
>>
>>
>> > Date: Tue, 18 Jan 2011
gt; it up.
> Regards - Dave
>
>
>
>
> > Date: Tue, 18 Jan 2011 23:24:56 -0800
> > Subject: Re: $$Excel-Macros$$ Re: Concatenate Value Problem
> > From: pansari.man...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > Any Help Pls..
Hi Manish,
Please attach the solution you have. Perhaps one of us may be able to speed it
up.
Regards - Dave
> Date: Tue, 18 Jan 2011 23:24:56 -0800
> Subject: Re: $$Excel-Macros$$ Re: Concatenate Value Problem
> From: pansari.man...@gmail.com
> To: excel-macros@googlegroups.
Any Help Pls..
-
Manish
On Jan 18, 5:42 pm, Manish wrote:
> Thanks Manoj.
>
> It’s really what I was looking for. But it is taking too much time to
> process the result.
> Is it possible to make it faster ??
>
> My excel getting stuck/Not Responding, while I change/add the data or
> copy the for
Thanks Manoj.
It’s really what I was looking for. But it is taking too much time to
process the result.
Is it possible to make it faster ??
My excel getting stuck/Not Responding, while I change/add the data or
copy the formula in another cell.
Pls suggest. Thanks in advance.
Regds,
Manish Pa
Hey Manish,
Hope this might help you
Cheers,
Manoj Kumar
On Mon, Jan 17, 2011 at 10:43 AM, Manish wrote:
> is it possible or not??? :(
> any help pls.
>
>
> -
> Manish Pansari
>
> On Jan 14, 11:21�am, Manish wrote:
> > Dear Group Friends,
> >
> > I have two work sheet. Sheet1 contai
is it possible or not??? :(
any help pls.
-
Manish Pansari
On Jan 14, 11:21�am, Manish wrote:
> 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 concatena
> There are 10 kinds of people: Those who understand binary and those who
> don’t.
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
>
> On Behalf Of Adam Lazzarato
> Sent: Monday, June 22, 2009 11:42 PM
> To: MS EXCEL A
22, 2009 11:42 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Concatenate cells and separate values with
commas
=concatenate(A1,",",A2)
Seems give the effect I am looking for. I just need a fast way to make
it...
=concatenate(A1,",",A2,",",A3,",A4,&
Hey Adam,
Use this function to concatenate multiple rows.
Alt + F11 to open the VB editor
Insert\Module
Paste the code below in the edit window
Then put this formula in any cell
=CommaCon(A1:A4)
Code Starts Here
Function CommaCon(rng As Range) As String
'
' CommaCon Function
'
Dim
Hi Adam,
Do you really want 1400 email addresses all in one cell? I'm not sure if
they'll fit...
For some reason, the CONCATONATE worksheet function doesn't allow CONCAT(A1:A50)
The concatenation can be done easily in VBA, but what you want done with the
final result is another matter.
Regar
=concatenate(A1,",",A2)
Seems give the effect I am looking for. I just need a fast way to make
it...
=concatenate(A1,",",A2,",",A3,",A4,"," ",",A1399,",",A1400)
Adam
On Jun 22, 12:37 pm, Harmeet Singh wrote:
> Pleas see attached file
>
> On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato
>
Sorry, but unless I did something incorrectly, I am not sure this is
what I was looking for.
When you say 'paste into filed' I am not sure what you mean, so I just
pasted the data range B2:B28 into a word document, and the data didn't
show up how I expected.
I am trying to take all 1400 rows, fi
Hi Adam,
If you are using Excel 2007, This would be a task for some keystrokes
You need to :
1. Copy the data and transpose entire data in a single row.
2. Copy the entire row and paste the data in a notepad.
3. In the notepad, copy blank space between e-mail IDs.
4. Press Ctrl+H and Paste t
Do this..
Assuming column A as email id starting from A2
B2 (=A2&",")
B3 (=B2&A3&",")
Now drag the formula in cell B3 below in column B
do copy-> pastespecial -> values for the last cell in column B
You will have the information in the required format..
Nishant
On Jun 22, 9:37 pm, Harmeet
Pleas see attached file
On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato wrote:
>
> 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 re
Exactly what I was looking for Thanks, Steve
On Apr 7, 5:55 am, Dave Bonallack wrote:
> Hi Steve,
> Try this code. It assumes data is in Columns A and B, as stated, and that the
> data starts in Row 2.
>
> Sub Steve()
> Application.ScreenUpdating = False
> A = 2
> B = 2
> C
Hi Steve,
Try this code. It assumes data is in Columns A and B, as stated, and that the
data starts in Row 2.
Sub Steve()
Application.ScreenUpdating = False
A = 2
B = 2
C = 2
For i = 1 To 100
Do Until Cells(A + 1, 1) <> ""
Cells(B, 2) = WorksheetFunction.t
hello Steve ,
try this
= concatenate( Box with, Cover and,4 slotted sides)
u can there by combined all the above rows into one
alternatively
=concatenate(rowc2,rowc3, rowc4)
will give the required result
thankx n regards
Rajat Jain
kolkata
rajatv...@gmail.com
On Tue, Apr 7, 2009 at
Steve,
You can do it with a simple formula if you want:
If you have data in cell A2 and B2 you want to join, the following formula
will work:
=A2&" "&B2
Then you can copy and paste special (Values)
Norman
On Mon, Apr 6, 2009 at 4:55 PM, Steve wrote:
>
> Hi,
>
> I could really use some help
Is it something you have to do often? or is it one time?
It could be done with a formula, but if it has to be done often, then it would
be better with a macro.
pretty easy with a macro...
Paul
From: Steve
To: MS EXCEL AND VBA MACROS
Sent: Monday, April 6,
=A1&B1&TEXT(C1,"HH:MM:SS")
Regards
Harish Upadhyay
On 10/29/08, vinu <[EMAIL PROTECTED]> wrote:
>
>
> How to concatenate the below one.
>
> A1=India
> B1=Bangalore
> C1=12:10Am
>
> Thanks in advance.
> Vinu.
>
> >
>
--~--~-~--~~~---~--~~
Visit the blog to download
Thanks a lot!!
On Oct 30, 8:26 pm, "Ajay Varshney" <[EMAIL PROTECTED]>
wrote:
> =A1&" "&B1&" "&TEXT(C1,"HH:MM AM/PM")
> Use the above forlula
>
>
>
> On Thu, Oct 30, 2008 at 11:19 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> > How to concatenate the below one.
>
> > A1=India
> > B1=Bangalore
> > C1=12
=A2&" "&B2&" "&TEXT(C2,"HH:MM AM/PM")
Use the above formula
On Thu, Oct 30, 2008 at 11:15 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> Hi this works well.
> How to concotenat the time formate for eg:
> MS Exce 12:15 AM how to do this..
>
> Regrds,
> vinu.
>
> On Oct 29, 9:18 am, "Bhavish Poddar"
Vinu,
Find the attached excel for your solution.
Manish
-Original Message-
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of vinu
Sent: Thursday, October 30, 2008 11:19 AM
To: MS Excel & VBA Macros
Cc: [EMAIL PROTECTED]
Subject: $$Excel-Macros$$ Concatenate
How
=A1&" "&B1&" "&TEXT(C1,"HH:MM AM/PM")
Use the above forlula
On Thu, Oct 30, 2008 at 11:19 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> How to concatenate the below one.
>
> A1=India
> B1=Bangalore
> C1=12:10Am
>
> Thanks in advance.
> Vinu.
>
> >
>
--~--~-~--~~~---~--~
Hi this works well.
How to concotenat the time formate for eg:
MS Exce 12:15 AM how to do this..
Regrds,
vinu.
On Oct 29, 9:18 am, "Bhavish Poddar" <[EMAIL PROTECTED]> wrote:
> Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy")
> where A1 = MS
> B1 = Excel
> C1 = 29-0ct-08
>
> On Fri
Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy")
where A1 = MS
B1 = Excel
C1 = 29-0ct-08
On Fri, Oct 24, 2008 at 11:31 AM, H Upadhyay <[EMAIL PROTECTED]>wrote:
> Pls chk attached file
>
> Regards
> Harish Upadhyay
>
>
>
> On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>
Hi,
Use the below formula.
=A1&B1&TEXT(C1,("dd-mm-yy"))
On 10/26/08, karthik balasubramanian <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Use this formulae:
>
> =CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-;@"))
>
> COL: E F G ROW ms excel 24-oct-2008
>
> E17 is m
Hi,
Use this formulae:
=CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-;@"))
COL: E F G ROW ms excel 24-oct-2008
E17 is ms
F17 is excel
g17 is 24-oct-2008
I hope this helps.
with regards
karthik.B
On Fri, Oct 24, 2008 at 1:01 AM, H Upadhyay <[EMAIL PROTECTE
Dear Shyam,
Below is the formula for your query
*=CONCATENATE(A1&B1&""&TEXT(C1,"dd-mmm-yy"))*
regards,
siva
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
> out with this:
>
> Query:
>
> Colum
Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy"))
where D8 = MS
D9= Excel
D10 = 24 - Oct - 08
u will get the answer.
On Fri, Oct 24, 2008 at 7:04 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
>
hi shyam
can u try this one
=CONCATENATE(D12," ",D13," ",TEXT(D14,"dd-mmm-"))
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> 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 : Exc
Hi Gyanesh,
Thanks so much Its working fine... :)
Cheers
Shyam
2008/10/24 gyanesh jain <[EMAIL PROTECTED]>
> Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy"))
>
> where D8 = MS
> D9= Excel
> D10 = 24 - Oct - 08
>
> u will get the answer.
>
> On Fri, Oct 24, 2008 at 7:04 AM, [EMAI
Hi Dear,
Use formula =A1&" "&B1&" "&TEXT(C1,"D-MMM-YY").
Regards
CA. Atul Singhal
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: October 24, 2008 7:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Concatenate Formula
Hi All,
I have an
hi.
do one thing first paste special the cell value which has date then try
concatenation
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> 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
Hi,
Pls gohead with this attachment.
WISH U HAPPY DIWALI
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Thu, 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROT
Pls chk attached file
Regards
Harish Upadhyay
On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> 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
58 matches
Mail list logo