Dear members,
I have an excel sheet with numbers, but they contain a non numeral
character at the end and i can not therefore sort nor do any mathematical
function on the . Please assist with a formula of getting rid of the
non-number characters so i can sort and add.
Regards,
Boreh
--
Join
Hi Robinson,
Use =trim(your number)
Regards
Karan Singh
On Mon, Sep 17, 2012 at 12:41 PM, Robinson Boreh rbo...@gmail.com wrote:
Dear members,
I have an excel sheet with numbers, but they contain a non numeral
character at the end and i can not therefore sort nor do any mathematical
Hi Robin,
can use this for cleaning the number:-
=IFERROR(CLEAN(TRIM(A2)),)
Thanks Regards,
*Deba Ranjan P*
On Mon, Sep 17, 2012 at 12:47 PM, Karan Singh karan1...@gmail.com wrote:
Hi Robinson,
Use =trim(your number)
Regards
Karan Singh
On Mon, Sep 17, 2012 at
Hi Boreh
use this =VALUE(LEFT(A2,LEN(A2)-1))
Enjoy
Regards
prince
On Monday, September 17, 2012 12:42:09 PM UTC+5:30, kip wrote:
Dear members,
I have an excel sheet with numbers, but they contain a non numeral
character at the end and i can not therefore sort nor do any
Hi Robin,
Rather than using my earlier solutions use below one :
=trim() copy paste as value Convert to Number.
Regards
Karan Singh
On Mon, Sep 17, 2012 at 12:52 PM, Deba Ranjan drdeva...@gmail.com wrote:
Hi Robin,
can use this for cleaning the number:-
From: Siraj Momin (BTG)
Sent: Monday, September 17, 2012 7:23 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C
WITH COLUMN E AND G AND UPDATE THE VALUES.
Hi prince
May be I did not explain you properly see the attachment
Dear Raobinson,
Please try..
*=--SUBSTITUTE(A2,CHAR(10),)*
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Mon, Sep
Hi,
if all values are in same column use convert text to column wizard..
On 17 September 2012 13:12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Raobinson,
Please try..
*=--SUBSTITUTE(A2,CHAR(10),)*
--
With Regards,
Noorain Ansari
http://
Hi Friednds,
Please help me to extract only text from alphanumeric word for example
NT2 = *NT*
SUB123= *SUB*
WELC90= *WELC*
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Dear Sundar,
Please use below formula :
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10123456789))-1)
Rgds
Karan Singh
On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friednds,
Please help me to extract only text from alphanumeric word for example
NT2 = *NT*
Hi Sundarvelan
i hope this will help u .
=LEFT(C32,FIND({1,2,3,4,5,6,7,8,9,0},C32,1)-1)
Regards
Prince
On Monday, September 17, 2012 2:47:48 PM UTC+5:30, Sundarvelan wrote:
Hi Friednds,
Please help me to extract only text from alphanumeric word for example
NT2 = *NT*
SUB123=
Thanks prince141987 Karan1237
Thanks
N.Sundarvelan
9600160150
On Mon, Sep 17, 2012 at 3:00 PM, Karan Singh karan1...@gmail.com wrote:
Dear Sundar,
Please use below formula :
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10123456789))-1)
Rgds
Karan Singh
On Mon, Sep 17, 2012 at 2:47
Hello Vabs,
Thanks again.Really helpful group with helping hand.
Love you all because you guys help without shouting.
On Sat, Sep 15, 2012 at 5:15 PM, Vabz v...@vabs.in wrote:
Hi
Thanks.. for acknowledgement!! :)
Happy to Help Excel Lovers..
Cheerz..
Rgds//Vabs
On Saturday,
Dear Don Guillett,
Thanking you for your kind assistance and help.
Really appreciated.
On Sat, Sep 15, 2012 at 7:01 PM, dguillett1 dguille...@gmail.com wrote:
Is the attached what you want for the SECOND line
Don Guillett
Microsoft Excel Developer
SalesAid Software
Please somebody send me advanced array formula examples.
I have knowledge of array formulas but at basic level. I want to be savvy
in array formulas.
Please Help me.
Regards,
Waseem Saifi
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Dear Santosh,
You are true but logic is set by Karan Prince based upon requirement.
Rgds//Vabs
On Monday, September 17, 2012 3:28:56 PM UTC+5:30, santosh wrote:
Hi Karan,
Your formula works fine when the value starts with text.If the value
starts with a number it does't work.
Any
Have you tried Conditional formating?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
Hi Paul,
Conditional format also works on value of cell not on formula of cell.
I want to work on formula insted.
Rgds//Vabs
On Monday, September 17, 2012 4:33:25 PM UTC+5:30, Paul Schreiner wrote:
Have you tried Conditional formating?
*Paul*
Hello All,
I have merged two macros to avoid sending mail either without subject or
without attachment via outlook.
My problem is this macro is currently working for attach word only this
should work for other word also like include, enclose also.
I'm not expert of macro but I learned little
Hi Sundarvelan,
Kindly find the attached solved sheet. I hope it will help you.
Regards,
Kuldeep Singh
On Mon, Sep 17, 2012 at 4:17 PM, Vabz v...@vabs.in wrote:
Dear Santosh,
You are true but logic is set by Karan Prince based upon requirement.
Rgds//Vabs
On Monday, September 17,
Sorry,
I actually wrote this last week, but evidently never posted it!
I noticed that your code example and your sample file and description is
different.
you SAID that if you find a match, you want to replace B with F and D with H
but in your code:
Cells(r1, f) = Cells(r, b)
Cells(r1, h) =
I'm not sure what you mean.
You want to work on the FORMULA and NOT the VALUE?
Then what did you mean by manually punching in numbers ??
I guess we're going to have to have some sample data to work with.
Paul
-
“Do all the good you can,
By all the means
Back to one of my several earlier questions:
Are the Item Master rate dates regular?
That is: Will there be an entry for a specific item every
week/month/quarter/year??
If so, then we could develop a Dictionary Object and store, say, each Item
Master and the rate for each Quarter.
Then, from
Dear Sundar,
See attached sheet, hope it will help to you.
On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friednds,
Please help me to extract only text from alphanumeric word for example
NT2 = *NT*
SUB123= *SUB*
WELC90= *WELC*
Thanks
N.Sundarvelan
And then send the file to some of us to break the password.
I would suggest different workbooks with the workbook protected. Safer.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Monday, September 17, 2012 7:17 AM
To:
I did use any code, I use conditional formatting
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sara Lee
Sent: 17 September 2012 1:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
=LEFT(A2,LEN(A2)-1)*1
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Robinson Boreh
Sent: 17 September 2012 12:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert to number
=LEFT(B2,MATCH(TRUE,ISNUMBER(VALUE(MID(B2,ROW($1:$10),1))),0)-1)
With CSe
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 17 September 2012 2:47
To:
Did you try Cpearson
http://www.cpearson.com/excel/ArrayFormulas.aspx
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: 17 September 2012 3:57
To: excel-macros@googlegroups.com
Dear Rajan,
Yes definitely it works..
But I wanted to apply condition on select range because my range would also
include another columns.
Cheers Thanks..
Rgds//Vabs
On Monday, September 17, 2012 7:42:43 PM UTC+5:30, Rajan_Verma wrote:
*See if it help*
* *
* *
*Regards*
*Rajan
I have created below macro before sometime you can use this and can add more
words condition in Red Line
Option Compare Text
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
Dim strBody As String
Dim strMsg As
Hi Experts,
I'm again in to a problem whic is silly but still i can't make it.I
calculate the scores for individuals seperately but this time i want to
make all under one table.For this, i have created a pivot table for
Calculating the Score, I have used Calculated field which is not giving
Thanik you very much, Rajan. This is incredible.
Will this also work for people who run Excel 2010? Or are there other
options available in 2010?
Really appreciate your support. This is fantastic.
Christoph
On Friday, September 14, 2012 11:37:22 AM UTC-4, Rajan_Verma wrote:
*HI*
* *
Yes.. it will work for 2010 also, even I have created this in 2010 J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chris
Sent: 17 September 2012 8:28
To: excel-macros@googlegroups.com
Subject: Re:
Hi, I´m sorry to be writing in this post, but I don´t think it is necessary
to open a new post, because I have the same problem but my mail is between
, I can I extract this? thanks
On 28 August 2012 14:53, vijayajith VA vijayajith...@gmail.com wrote:
Hi Zibrean,,
Please use below formula
Dear Jorge
HI
U can try this..
=TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND( ,A4 ,FIND(,A4))-1), ,REPT(
,99)),99))
If doesn't work share sample data.
Cheers..
Regards//Vabs
On Mon, Sep 17, 2012 at 8:49 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi, I´m sorry to be writing in this post, but I
Hi Ex(cel)perts,
I am in need of a macro based search tool in Excel 2010.
If I type some text in cell A2, then it look for in the column range
A5:F1 and filtered data should be shown.
With Best REgards,
Madaiah
--
Join official facebook page of this forum @
ok.. what have you tried so far?
Are you using filters?
or will the string potentially appear in any column?
in which case you'd want to find the string, and hide the row.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
Hi,
How to insert specific column values from excel to sql table using visubal
basic dot net.
Thanks,
Sharma
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Paul- Currently I am using filters and CTRL + F.
The string might appear in any of the columns and when I type the string in
a cell or text box and press enter (or click on a button)should display the
rows where the string is available.
I want this tool to be prepared for the people who are not
Is there anything stronger then Banned?
Maybe Flogged and Banned?
I think every person that receives the spam should respond DIRECTLY TO HIM
once for each time you receive it.
I don't mind someone that fails to read the guidelines and sends something
like this ONCE.
But getting five or six of
looks a lot like one of mine..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Monday, September 17, 2012 10:57 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fw : Search tool in Excel sheet
In attached file you can
Yes Don , its yours .. I just reuse it to save time J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 17 September 2012 9:35
To: excel-macros@googlegroups.com
Subject: Re:
Hi Putta Madaiah,
Do u want to highlight the cells or Columns or Rows in which ur intended
string found ?
regards
Prince.
On Monday, September 17, 2012 9:03:55 PM UTC+5:30, Putta Madaiah wrote:
Hi Ex(cel)perts,
I am in need of a macro based search tool in Excel 2010.
If I type some
Shorter one. In D2
=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2,FIND(@,A2)),CHAR(160), ),
,REPT( ,99)),99))LEFT(MID(A2,FIND(@,A2)+1,255) ,FIND(
,MID(A2,FIND(@,A2)+1,255) )-1)
In E2
=TRIM(SUBSTITUTE(A2,D2,))
Kris
ExcelFox http://www.excelfox.com/forum/forum.php
--
Join official facebook page of
wow...
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
this is a Doubt?
Doubt: a)to consider unlikely , b) to lack confidence in.
Great J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Krishna Kumar
Sent: 17 September 2012 9:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula to Separate Company name and
Hello friends,
I'm using Excel 2010 on Windows 7 and I'm trying to find a code that
autamatically downloads the page that, for now, I can only access by
navigating in my browser to the address
http://www.bmfbovespa.com.br/opcoes/opcoes.aspx?Idioma=pt-br
and then clicking on the tab named
Hi team,
Need example for how to insert specific column values from excel to sql
table. using vb.net
Thanks,
Sharma
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread
Olá
Gafanhoto estais no Brasil?
2012/9/17 Gafanhoto andre.ac...@gmail.com
Hello friends,
I'm using Excel 2010 on Windows 7 and I'm trying to find a code that
autamatically downloads the page that, for now, I can only access by
navigating in my browser to the address
Hi,
The below formula is a generalized version. Hope it works.
Even the string starts with numbers, this formula works.
*
Heed help is sorting hidden rows. Is there a vb macro code that someone can
help me with to sort reguardless if the rows are hidden or not.Thanks in
Advance!!!
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Dear SG,
Calculated field works well in table.Try Creating a table for the data than
a pivot table. If you want a calculated field in Pivot Table go to
formulas tab then select a calculated field and select the required
function and the feils which you want to make a calculated field.
53 matches
Mail list logo