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/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Mar 5, 2012 at 4:17 PM,
Hi,
Try it...
=RIGHT(A1,LEN(A1)-FIND(-,A1,1))
Regards,
MARIES.
On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
**
Dear Group,
please help to extract the numbers in one cell to another
through formula.
Regards,
Muneer,
CC
--
FORUM
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
Dear all,
Help me in this..!
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
https://plus.google.com/43524614789164919/posts
http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann
http://karanxel.blogspot.com/ http://karanxel.wordpress.com/
Hi Karan,
Please find the attached sheet. I am trying my level best to help you .
On Thu, Oct 20, 2011 at 1:55 PM, karan 1237 karan1...@gmail.com wrote:
Dear all,
Help me in this..!
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
Thanks a lot neil but there is a query (Pincode) which has not solved yet.
I've to extract Pin Code from the text as I'v written on mail worksheet.
Kindly help me in this.
Thanks
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237