$$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Jayaprakash S
Dear Experts, Good Morning. I have a case where in Data is built in with Text (1 2 Digits, Eg: 1 Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I required help to replace Olny the Text. enclosed sample file. Please help. Thank you. JP. -- -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread अनिल नारायण गवली
Dear Bhat. Pls find Attached Sheet FYI Regards, Gawli Anil On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S wrote: Dear Experts, Good Morning. I have a case where in Data is built in with Text (1 2 Digits, Eg: 1 Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I required

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, Please use.. *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT(48:58))),)* On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S bhat.jayaprak...@gmail.comwrote: Dear Experts, Good Morning. I have a case where in Data is built in with Text (1 2 Digits, Eg: 1 Uttar Pradesh, 20 Jharkhan) and

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, See attached sheet. On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear JP, Please use.. *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT(48:58))),)* On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts,

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread अनिल नारायण गवली
Pls find attached sheet FYI Regards, Gawli Anil On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear JP, Please use.. *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT(48:58))),)* On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S wrote: Dear Experts, Good

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Jayaprakash S
Dear Noorain, My data is in Column C... if i change the column in your formula then it is giving the Text with number only... Please relook in to it and help me. thank you. JP. On Fri, Jul 27, 2012 at 12:48 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear JP, See attached sheet.

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, Formula is working fine.. Please see attached sheet. On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S bhat.jayaprak...@gmail.comwrote: Dear Experts, Good Morning. I have a case where in Data is built in with Text (1 2 Digits, Eg: 1 Uttar Pradesh, 20 Jharkhan) and without text

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, I got my mistake..Just i am sending you correct answers. On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear JP, Formula is working fine.. Please see attached sheet. On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S bhat.jayaprak...@gmail.com

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Deba Ranjan
Dear JP, See the attached, hope this too will help you for extracting text. Thanks Regards, *Deba Ranjan P* On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear JP, Formula is working fine.. Please see attached sheet. On Fri, Jul 27, 2012 at

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, by Formula, You can use.. =TRIM(RIGHT(C7,LEN(C7)-COUNT(--MID(C7,ROW(INDIRECT(1:LEN(C7))),1))) with ctrl+shfit+enter See attached sheet. On Fri, Jul 27, 2012 at 1:09 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear JP, Please See attached sheet. On Fri, Jul 27, 2012 at

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Jayaprakash S
Excellent Master!!! was looking out the answer in formula only... so working superb !! thanks a ton to every one for your valuable efforts !! cheers JP On Fri, Jul 27, 2012 at 2:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear JP, by Formula, You can use..

RE: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Priti_Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 27 July 2012 12:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text Dear JP, See attached sheet. On Fri, Jul 27, 2012 at 12:47 PM

Re: $$Excel-Macros$$ Text to Numbers

2011-08-26 Thread Venkat CV
Hi, It's in Text only just Copy and paste and change Format cells as a Number... *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants to

Re: $$Excel-Macros$$ Text to Numbers

2011-08-26 Thread Karthi Kumar
Hi, Remove the spaces and comma by Search and Replace (Ctrl+H) option. Then try converting to numbers. With Regards, Karthi On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants

Re: $$Excel-Macros$$ Text to Numbers

2011-08-26 Thread XLS S
Hey Amit, open this e-mail in internet explores and then copy past On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants to convert them in number to have sum of it. Let me know

RE: $$Excel-Macros$$ Text to Numbers

2011-08-26 Thread Rajan_Verma
@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Friday, August 26, 2011 7:18 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Text to Numbers Dear Friends, I have recd the following data in email body itself wants to convert them in number to have sum of it. Let me know how