how to go about it and all this data should appear one after
the other and in one whole cell.
--- On *Tue, 7/28/09, Dave Bonallack davebonall...@hotmail.com* wrote:
From: Dave Bonallack davebonall...@hotmail.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in
excel
--- On Tue, 7/28/09, Mahesh mahender.bi...@gmail.com wrote:
From: Mahesh mahender.bi...@gmail.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: excel-macros@googlegroups.com
Date: Tuesday, July 28, 2009, 12:43 PM
Hi Shannu,
For that u can use =CONCATENATE
the other and in one
whole cell.
--- On Tue, 7/28/09, Dave Bonallack davebonall...@hotmail.com wrote:
From: Dave Bonallack davebonall...@hotmail.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date
address
All this details to be extracted from diff cells and pasted or copied in
one single cell.
Regards,
Shan
--- On *Tue, 7/28/09, Mahesh mahender.bi...@gmail.com* wrote:
From: Mahesh mahender.bi...@gmail.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click
All this details to be extracted from diff cells and pasted or copied in
one single cell.
Regards,
Shan
--- On Tue, 7/28/09, Mahesh mahender.bi...@gmail.com wrote:
From: Mahesh mahender.bi...@gmail.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
Use Concatenate with
Char(10) ( refers to the alt+enter in cell)
or
=Designation CHAR(10) Name CHAR(10) So on
or
= A2 CHAR(10) B2 CHAR(10) C1 so on
or
= A2 A1 B2 A1 C1 so on (where A1 refers to = Char(10)
whatever applicable.
Set Word Wrap = True from Format Cells. Otherwise you
Dear members,
Can anyone assist Pinky ? She is in urgent need.
Thanks.
On Jul 27, 3:48 pm, Pinky Sangani pinky.sang...@gmail.com wrote:
HI
i need this ASAP i have 1 long string in 1 of the cell in the
worksheet where in i have 2 segregate the datas in it to various
columns as in the THe
Pinky...
can u please attach the file..so that the solution can be worked out in that
itself
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Mon, Jul 27, 2009 at 4:18 PM, Pinky Sangani pinky.sang...@gmail.comwrote:
HI
i
Hi.
Try :
Sub test()
ActiveCell = YES ABC NO XYZ YES AGH NO HGT
tabl = Split(ActiveCell, )
For i = 0 To UBound(tabl)
ActiveCell.Offset(, i + 1) = tabl(i)
Next i
End Sub
Regards.
Daniel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-
HI Pinky
Use Text to columns options for segregating the data into columns :)
Ashish
--- On Mon, 27/7/09, Ayush Jain jain_ayus...@yahoo.com wrote:
From: Ayush Jain jain_ayus...@yahoo.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: MS EXCEL AND VBA MACROS
Dear Pinky,
Can you please attach a sample file. This will help a quick solution
Regards,
Andy
On Mon, Jul 27, 2009 at 9:22 PM, Ayush Jain jain_ayus...@yahoo.com wrote:
Dear members,
Can anyone assist Pinky ? She is in urgent need.
Thanks.
On Jul 27, 3:48 pm, Pinky Sangani
Hello All,
Please find attached input and desired output of Pinky.
Thanks for your help,
Ayush Jain
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
.
From: jainayus...@gmail.com
Date: Mon, 27 Jul 2009 23:22:18 +0530
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: excel-macros@googlegroups.com
CC: pinky.sang...@gmail.com
Hello All,
Please find attached input and desired output of Pinky.
Thanks for your help
Hi..
wondering y u dint go for text to columns
--- On Mon, 7/27/09, Pinky Sangani pinky.sang...@gmail.com wrote:
From: Pinky Sangani pinky.sang...@gmail.com
Subject: $$Excel-Macros$$ Segregation of data on a button click in excel
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Bonallack davebonall...@hotmail.com wrote:
From: Dave Bonallack davebonall...@hotmail.com
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date: Tuesday, July 28, 2009, 10:23 AM
#yiv605464535 .hmmessage P
15 matches
Mail list logo