Hi,
"=LEFT(C2,FIND("" "",C2)+2,99"
This is incorrect. It's missing a closing bracket, and the ,99 is wrong.
What are you trying to acheive?
Regards - Dave.
> Date: Fri, 2 Jul 2010 20:00:54 -0700
> Subject: $$Excel-Macros$$ Entering Formulas
> From: jazz...@shaw.ca
Thanks Paul!!
Its working absolutely fine. is there any formula to perfome the same.
Deepak
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
hi dave
can you explain the formula how it is working
=FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(
SUBSTITUTE(A1," ",""
On Fri, Jul 2, 2010 at 10:29 PM, praveen kumar wrote:
> Here with have attached one pdf file. from that if i copy paste data
> to excel then it will show
Dear Krisha ,
Thank you very much.
Worawat
2010/7/2 krishna mummina
> CLICK ON THE TEXT, YOU WILL GET THE PROPERTIES OR ELSE, RIGHT CLICK ON
> THAT AND PROPERTIES, THERE YOU WILL FIND WHAT YOU WANT.
>
> On 7/2/10, worawat kh wrote:
> > Dear Group ,
> >
> >How to increase size and color
Dave, I think Praveen was looking for the count from right to left.
Your example formula results with 17 not 8. However, building on your
formula, you can simply subtract from the length of the cell. Here is
counting from right to left:
=LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(
I tried variations on the following:
With Worksheets("Call List")
.Range("L2").Formula = "=LEFT(C2,FIND("" "",C2)+2,99"
.Range("M2").Formula = "=IF(ISERROR(LEFT(MID(C1,FIND(""
"",C1)+1,99),1)*1),,LEFT(MID(C1,FIND("" "",C1)+1,99),FIND(""
"",MID(C1,FIND("" "",C1)+1,99"
.Range("N2"
Hi,
I don't think you can say "For i = 1 to i" since i is undefined.
Regards - Dave
> Date: Fri, 2 Jul 2010 11:52:06 -0700
> Subject: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing
> From: bpascal...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
> Could you please te
I'm converting a lot of VBA code from using absolute references to
named ranges.
Here is an example I'm not sure how to revise.
The original code references rows 2 to 259 in Column A. I have since
named A2:A259 "MyRange" but the original code refers to "iRow = 2 To
259". How can I change this to
Hi,
Could you please tell me why this code is not working? From a
programming background, i see no reasons why the code is not giving
worksheets names through this for loop :
Option Explicit
Public Sub SheetList()
Dim W As Worksheet
Dim i As Integer
Range("A1").Select
For i =
Here with have attached one pdf file. from that if i copy paste data
to excel then it will show country name & numbers together like this
1 United States 14,093,310
2 China 7,909,261
I want to seprate this country names & numbers here. If have found
out the position of the space from the right
Hi
Can you send me the file so that I can give a solution.
Bye
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
--
--
Some important links for excel users:
1. Follow us o
CLICK ON THE TEXT, YOU WILL GET THE PROPERTIES OR ELSE, RIGHT CLICK ON
THAT AND PROPERTIES, THERE YOU WILL FIND WHAT YOU WANT.
On 7/2/10, worawat kh wrote:
> Dear Group ,
>
>How to increase size and color of text in user form ?
>
> Thanks,
> Worawat
>
> --
> --
Hi praveen,
Let's say you have "United States of America" in "A1" cell and "
" (space) in "A2" cell.
Now you can run this code and get result in "A3" cell.
Enjoy!
Sub test1()
Dim currentCell, currentLength, currentSymbol, i, currentSpace, j
j = 1
Range("A2").Select
currentSpace = A
Hi Praveen,
It's a bit long-winded, but here's a formula to find the position of the last
space in Cell A1:
=FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,"
",""
Regards - Dave.
> Date: Fri, 2 Jul 2010 19:48:01 +0530
> Subject: $$Excel-Macros$$ Fwd:
> From: bhspra
Hi praveen,
we can find the position and could you please tell me why you need it.
Bye
On 7/2/10, praveen kumar wrote:
> Hi Friends,
>
> Is there any way to find the position of the space in a word from right
> side.
>
> Ex: United States of America - here the position of the space from
> right
Hi Friends,
Is there any way to find the position of the space in a word from right side.
Ex: United States of America - here the position of the space from
right side is 8.
--
Regards,
praveen
--
--
Some importa
HI Larry!
Thank you for your advice, I will keep this in mind going forward.
Have you specificaly converted any QuickBasic programs to VBA, if so
what do you think the work effort is on a scale 1 - 10 (10 being most
effort). Thank you again for your help and advice.
The Best
MikeB
On Jul 1, 7:
this macro seems to handle it:
Sub ReFormat_Data()
Dim LastRow, LastCol, R, C, RepRow
Dim SheetRaw, SheetRep
Dim Mgr_Name, Mgr_ID, City
SheetRaw = "Raw Data"
SheetRep = "Required Data"
Sheets(SheetRep).Range("A2:Z65000").ClearContents
Sheets(SheetRaw).Sel
Could not understand the objective.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of lucky singh
Sent: Tuesday, June 29, 2010 3:36 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Exrtact only numbers.
Hi
Dear tushar
I m ca practising in ludhiana punjab. I m doing practising in the field of
audit and taxation. I m having my own office and are running various activities
like tin fc, cfc, doing digital signature business and taxation software
business besides doing income tax and service tax pra
Hi Friends
I have attached a file, there are two sheets 1st is the raw data and 2nd
sheet has final data.
actually i have a large number of data to work on. is there any formula or
simple technique to do the same in quickly.
Deepak Rawat
--
--
Hi Magandeep,
I am also a CA practicing in Pune..I am not an expert, but sometimes do
coding for enjoyment. I have a lot of such small assignments, for my daily
requirements. If you are interested, I can share you some tips.. Before that
let me know what do you do and some words about yourself.
O
Dear Team,
Can you please help me below request.Thanks in advance.
-- Forwarded message --
From: Nagendra Modupalli
Date: Mon, Jun 28, 2010 at 8:48 AM
Subject: $$Excel-Macros$$ Help in MS Word macro
To: excel-macros@googlegroups.com
Hi Team,
I have MS Word Invoices monthly mor
23 matches
Mail list logo