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.com>wrote: > 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 > general formatting to return the value. Returning the unit can't be done > with worksheet formulas, I don'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 & 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 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 at 11:29 AM, C.G.Kumar <kumar.bemlmum...@gmail.com>wrote: > > 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.com> 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 > 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 separate in unit > name and the price. > > plz consider it and tell me. > > Thanks to you all. > > 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 > > > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
