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
Hi,
Thanks for opening up an area of XL that I'd never even heard about. I did some
research, and have found the following page to be most informative on the
subject of GET.CELL
http://www.mrexcel.com/forum/showthread.php?t=20611
Regards - Dave.
Date: Mon, 30 Aug 2010 11:52:47
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 Name
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, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
You have custom formatting in the both of your main data columns, which
means that only the numeric value is
Hi,
Unfortuneately, your data is not as it appears. On the workbook you posted,
select cell B5.
Look in the formula bar (just above the Column headers)
You will see: 180.5 even though the cell displays 180.500 kg
This is because custom cell formatting in B5 puts in the extra info.
Now, in
check the attachment if it helps
On Sun, Aug 29, 2010 at 1:21 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
Unfortuneately, your data is not as it appears. On the workbook you posted,
select cell B5.
Look in the formula bar (just above the Column headers)
You will see: *180.5*
Hm, for some reason I only received this email after I send the last one.
Ashish's solution is much more elegant than mine.
Please forgive for sending useless attachments to your emails.
On Sun, Aug 29, 2010 at 5:32 AM, ashish koul koul.ash...@gmail.com wrote:
check the attachment if it helps
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, 2010
Hello Sir,
I need help in separate the num alpha value in the one cell into another
two cells.so i am attaching a sample file in it, in sample file I have two
column and having the num and alpha value like 14.300kg or 23.30/kg so on...
and I have to separate these value in two column like 14.300
Hi,
You have custom formatting in the both of your main data columns, which means
that only the numeric value is entered. (Select one of the cells and see what
appears in the formula bar). The units are done with the formatting. So you
only need a simple =A2 sort of formula in a cell with
Could you please attach sample file.
Thanks Regards,
C.G.Kumar
On Fri, Aug 27, 2010 at 10:21 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
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
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
possible in the excel if yes how can it possible? basically it is in the
Price column and it having unit name also. so i want to
12 matches
Mail list logo
