RE: $$Excel-Macros$$ Extract the numbers....

2012-03-06 Thread Mohammed Muneer
Thanx! Regards, Muneer, CC. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, March 06, 2012 4:23 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extract the numbers

Re: $$Excel-Macros$$ Extract the numbers....

2012-03-06 Thread NOORAIN ANSARI
Dear Muneer, You can also use.. =MID(A1,FIND("-",A1,1)+1,LEN(A1)-LEN(FIND("-",A1,1)+1)) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Mon, Mar 5, 2012 at 4:1

RE: $$Excel-Macros$$ Extract the numbers....

2012-03-05 Thread Mohammed Muneer
Dear Maries, thanx for the help. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Monday, March 05, 2012 1:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extract the numbers

Re: $$Excel-Macros$$ Extract the numbers....

2012-03-05 Thread Maries
Hi, Try it... =RIGHT(A1,LEN(A1)-FIND("-",A1,1)) Regards, MARIES. On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer wrote: > ** > Dear Group, > please help to extract the numbers in one cell to another > through formula. > > > Regards, > Muneer, > CC > > -- > FORUM RULES (9

$$Excel-Macros$$ Extract the numbers....

2012-03-05 Thread Mohammed Muneer
Dear Group, please help to extract the numbers in one cell to another through formula. Regards, Muneer, CC -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula