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 Cell
act number
> 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 wrote:
>
> From: Mahesh
> Subject: $$Excel-Macros$$ Re: Segregation of data on a butt
ame
> contact number
> 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 * wrote:
>
>
> From: Mahesh
> Subject: $$Excel-Macros$$ Re: Segregati
to be assembled in one particular cell 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 wrote:
From: Dave Bonallack
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: "excel-m
--- On Tue, 7/28/09, Mahesh wrote:
From: Mahesh
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().
On Tue, Jul 28, 2009 at 10:44 AM, shannu
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 * wrote:
>
>
> From: Dave Bonallack
> Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in
> excel
> To: "excel-
Bonallack wrote:
From: Dave Bonallack
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: "excel-macros@googlegroups.com"
Date: Tuesday, July 28, 2009, 10:23 AM
#yiv605464535 .hmmessage P
{
margin:0px;padding:0px;}
#yiv605464535 {
font-size:10pt;font-fami
Hi..
wondering y u dint go for "text to columns"
--- On Mon, 7/27/09, Pinky Sangani wrote:
> From: Pinky Sangani
> Subject: $$Excel-Macros$$ Segregation of data on a button click in excel
> To: "MS EXCEL AND VBA MACROS"
> Date: Monday, July 27, 2009, 4:18 PM
>
> HI
> i need this ASAP i h
Dave.
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
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 Tuto
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 wrote:
>
> Dear members,
>
> Can anyone assist Pinky ? She is in urgent need.
>
> Thanks.
>
> On Jul 27, 3:48 pm, Pinky Sangani wrote:
> > HI
> > i need t
HI Pinky
Use Text to columns options for segregating the data into columns :)
Ashish
--- On Mon, 27/7/09, Ayush Jain wrote:
From: Ayush Jain
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: "MS EXCEL AND VBA MACROS"
Date: Monday, 27 July, 200
I think you just have to use Data->Text to Column->Delimited->Space->Finish
Saurabh Patel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Pinky Sangani
Sent: Monday, July 27, 2009 4:19 PM
To: MS EXCEL AND VBA MACROS
Subject: $$E
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-
> mac...@googlegro
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 wrote:
>
> HI
> i need this ASAP i have 1
Dear members,
Can anyone assist Pinky ? She is in urgent need.
Thanks.
On Jul 27, 3:48 pm, Pinky Sangani 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 String is like
> "YES
16 matches
Mail list logo
