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 >> Define
Name Formatting
Refer to : =GET.CELL(7,INDIRECT("RC[-1]",FALSE))
in the worksheet
a formula =Formatting
will returns "text of formatting" of the previous cell
We can then manipulate the "Formatting text" ( fx: "0.0000 Kg") to be "Kg"
see examples in the attachment
best regards,
siti
On Sun, Aug 29, 2010 at 11:13 AM, Ankit Agrawal <ankit.agrawal...@gmail.com>
wrote:
>
> 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 in one column
> and kg in second column.
> Plz help me in this criteria.
>
> thanks & regards
> Ankit Agrawal
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
