Hi Harmet,
MUCH shorter than mine! Very good.
Does need to be entered with Ctrl+Shift+Enter
Regards - Dave.
From: harmeet.hew...@gmail.com
Date: Wed, 31 Mar 2010 05:56:49 +0530
Subject: Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers
from a cell
To: excel-macros@google
*found one more method.*
*PFA file*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Mar 31, 2010 at 5:29 AM, Dave Bonallack
wrote:
> Hi,
> I've thought about it some more and have come up with a rediculously long
> formula that does the job.
>
>
> =MID(MID(A1,MIN(SEA
Hi,
I've thought about it some more and have come up with a rediculously long
formula that does the job.
=MID(MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),100),1,MIN(SEARCH({"a","b","c","d","e","f","g","h","I","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},
Thank you very much.
Your code was very useful
-Original Message-
From: "Daniel"
Date: Mon, 29 Mar 2010 10:57:18
To:
Subject: RE: $$Excel-Macros$$ Re: Continuous-Selection and transpose
Hello.
Give the following macro a try :
Sub test()
Dim c As Range
Dim ResAdr As String
Dim Ctr
Hi,
I can only get you part of the way at the moment.
The following formula removes all leading non-numeric characters.
ie: jdsdnc2123asdd will become 2123asdd
=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),100)
(assuming jdsdnc2123asdd is in A1)
See if someone else can help
Dear All,
Attached is the macro to extracting the numeric value from alphanumeric string.
--
Thanks Regards
Shyam
Software Engineer
'''
Hello Dear,
Following Is the attached macro for your problem.
Hope it will Help
Happy To help
:)
Shyam
On Tue, Mar 30, 2010 at 1:55 PM, Abhidha Dixit wrote:
> Dear All
>
> I am seeking for the reply of one queryy
> how to seperate alphats and no.
> eg: jdsdnc2123asdd
> iofruif687
Hi experts,
I have a huge date with time data some of the cells shown MM/DD/
Hr:MM format
Some of the cells shown MM/DD/ Hr:MM AM/PM format how I convert
MM/DD/ Hr:MM format.
I am not expecting below copy format. Or press F2 next press home next
press back space .
--
---
You add the server on VPN and that case it wil be access in you local
network and you can use it like locally
Regards
Santosh Bahuguna
On Sun, Mar 28, 2010 at 12:17 AM, Rajesh D wrote:
> Hi
>
>
> please advice me is there any way that excel file in the server can be
> accessed thru web
>
Paul,
To make the code re-usable I was looking to be able to select two
ranges (or pass two named ranges) and for the macro to do the rest.
To determine the upper-left cell of the second range would be
rng2.cells(1,1), but the bit I was struggling with was determining
from rngCell exactly which ce
Hi Paul,
Thanks its almost all what I need, but only one additional thing required
that is when ever I run a macro the out put alwasy with next row.
I mean
1st time in output sheet row 1
2 time in output sheet row2 like this it should go with next row rather then
in the same row. Can this be done
Dear All
I am seeking for the reply of one queryy
how to seperate alphats and no.
eg: jdsdnc2123asdd
iofruif68732fnvv
thnks in advance
regards
Abhidha
--
--
Some important links for excel users:
1. Follow us o
Dear All,
I am working on a project where I've prepared an userform for creating
Purchase Orders (PO). PO are Vendor wise, one PO for each vendor, no matter
how many items are in there. Now, the vendor part is okay, I have a list of
vendors from where the userform fetches the record.
When the use
Hi Jon
What about following simple macro...
Let me know if it suits you.
Greetings
Paul Willekens
'===
Sub Runner()
Dim aResult(4, 1)
Dim nPos
For nPos = 0 To 4
'Iteration code omitted
aResult(nPos, 0) = Cells(1, 1).Valu
Hi Archie,
First a question: I suppose your comparison starts with running the
macro, with as ActiveRange the first cell in range 1... Do you know,
at that point, what the first cell of range 2 is? Or is it one of the
tasks of this macro to search for it? I hope you know it and then: how
to pass
Thank you paul, This is working as I wanted. regards, Amith
On Mar 28, 11:13 pm, paulwillekens
wrote:
> OK, Amit, create your excel with from row 2 the files, from-paths and
> to-paths as specified... If you save that workbook as "c:\xls
> \MoveIt.xls" then the following "MoveIt.vbs" will do what
Dear Champs,
Need ur expat advise...
I got around 20 text files in a day,which had 13 to 15 columns separated by
"|" this sign. each file contains around 15 lacs or more line items.
when i import that text file in excel 2007, it takes the first 10 lacs
records; rest does not come.
Need ur help
17 matches
Mail list logo
