Hello siti,
thanks for your solution. but i did not get it how it has happened. please
can you brief it.and tell me any solution which may forever in excel.
with regard,
Ankit
--
--
Some important links for excel us
Thanks!
Regards - Dave.
Date: Mon, 30 Aug 2010 11:52:47 +0700
Subject: Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into
another two cells
From: villager.g...@gmail.com
To: excel-macros@googlegroups.com
Without VBA, we can create a NAME of formula
(menu Insert >
52:47 +0700
Subject: Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into
another two cells
From: villager.g...@gmail.com
To: excel-macros@googlegroups.com
Without VBA, we can create a NAME of formula
(menu Insert >> Name >> Define
Name Formatting
Refer to : =GET.C
>> So it's easy to get the values you want, but hard to get the units.
>> Regards - Dave.
>> ------------------
>> Date: Sun, 29 Aug 2010 12:41:21 +0530
>>
>> Subject: Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell
>> in
t's easy to get the values you want, but hard to get the units.
> Regards - Dave.
> --
> Date: Sun, 29 Aug 2010 12:41:21 +0530
>
> Subject: Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell
> into another two cells
> From: ankit
: Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into
another two cells
From: ankit.agrawal...@gmail.com
To: excel-macros@googlegroups.com
I did not get it what does it means? i m newly in excel, so plz decribe it
thanks & regards
ankit
On Sun, Aug 29, 2010 at 10:14 AM,
27;t think. You'll need VBA to copy the
> formatting of each cell to the new column, which will display the unit.
> Regards - Dave.
>
> --
> Date: Sun, 29 Aug 2010 09:31:23 +0530
> Subject: Re: $$Excel-Macros$$ Help in Separate the Num &
$$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into
another two cells
From: ankit.agrawal...@gmail.com
To: excel-macros@googlegroups.com
I am attaching a sample file, in this file, there are two column one for qty &
second one for the rate. I have to separate the qty c
I am attaching a sample file, in this file, there are two column one for qty
& second one for the rate. I have to separate the qty column in qty & its
unit & again in rate column.I have written in attach copy what format i
required in the sheet.
thanks & regards
Ankit Agrawal
On Fri, Aug 27, 201
Could you please attach sample file.
Thanks & Regards,
C.G.Kumar
On Fri, Aug 27, 2010 at 10:21 AM, Ankit Agrawal
wrote:
> Hello Sir,
>
> I have a data in which a column having the both numeric and alphabetically
> value but i want to separate these value into two column or two cells, is it
>
10 matches
Mail list logo
