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
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
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
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,
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
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.
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
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
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
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
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..
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
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
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
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
@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
16 matches
Mail list logo