try the inbuilt custom reformatter method.
with regards,
DM
On Wed, Mar 31, 2010 at 5:35 PM, nike wrote:
> Hi Paul Willekens,
> some of the cells are followed by " mm/dd/ hh:mm"(24Hrs ) format
> some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/
> hh:mm AM/PM".
>
> thx for
Hi,
With the full string in Column A, and headers 'Full String' in A1,
'Text' in B1 and 'Numbers' in C1, the following code will do the split
You seem to have leading and trailing spaces in your example.
How should these be treated?
Sub Splitter()
Dim NumString As String
Dim TextString
Hi there,
Are you familiar with AutoFilter?
If you build an employee Sheet with a column for each of the following
levels, you can select by any combination you wish.
A Component
B Division
C Senior Manager
D Emerging Manager
E Supervisor
F Employee Name
Ideally you will have tables with
Try this Jindon function:
Function TextNum(ByVal txt As String, ByVal ref As Boolean) As String
With CreateObject("VBScript.RegExp")
.Pattern = IIf(ref = True, "\d+", "\D+")
.Global = True
TextNum = .replace(txt, "")
End With
End Function
=TextNum(A1,1)
1 for Text only, 0 for Numbers on
Hello Master,
I have got a macro to track changes made in excel sheet. But the changes are
tracked in sheet1 of the same work book. I want a macro which keeps the
track of changes, in a different workbook and not the same workbook. In
short instead of keeping the log of changes in sheet1 of the sa
HI
any automation tools getting graphs in excel or any other automation tools
in excel to get report or any free softwares to get report automated.
On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:
> Hi,
>
> Kindly specify your requirements for automating
hi fellows
i hit a prob in excel sheet ... on change of figures, formula does not
updated automatically.. i have to get in the cell by pressing F2 and then
enter... its so pathetic... n wanna permanent solution.
is there any1 to help me out.
regards
--
Regards,
Abdul Rasheed
Confidence never co
Can u tell me how the raw data is arranged so that i can help you better
On Wed, Mar 31, 2010 at 6:36 PM, Shimmy wrote:
> Hello EXCEL_lent people.
>
> I am working for an emerging organisation/company. I would like to
> create a spreadsheet in Excel for my rganisation in which different
> compon
Thanks Dave
Its my pleasure to get appreciation from a legend (DAVE) :)
God bless u
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Mar 31, 2010 at 7:52 AM, Dave Bonallack
wrote:
> Hi Harmet,
> MUCH shorter than mine! Very good.
> Does need to be entered with Ctrl+Shift
Hello EXCEL_lent people.
I am working for an emerging organisation/company. I would like to
create a spreadsheet in Excel for my rganisation in which different
components and their activities will be filtered like in the said
spreadsheet like this:
There is one organisation, with 9 components.
E
Hi Paul Willekens,
some of the cells are followed by " mm/dd/ hh:mm"(24Hrs ) format
some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/
hh:mm AM/PM".
thx for u r sugesstion and i tried below customize from cell Format
menu.
thanks in adv.
Mynampat (Nike)
On Mar 31, 2:36 am,
Hello Dear,
I am just a little fish in sea of knowledge, my aim is to
Provide best solution to excel vba user.
Hope It Will Help
Happy To Help
:)
Shyam
On Wed, Mar 31, 2010 at 9:55 AM, Harpreet Singh Gujral
wrote:
> Shyam,
>
> "You are super hit", and this comment is something, which
On Wed, Mar 31, 2010 at 9:55 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Shyam,u r right man!!
>
> "You are super hit", and this comment is something, which i am sure i
> can give on your every solution
>
> Keep posting such tips :)
>
> Harpreet Gujral
>
> On Mar 30, 5:23 pm
Dear All
if there is a coloum containg mix of nos and alphabets
like ram12
moh12345an
132shyam
we need only alphabets what can we do
like ram
mohan
shyam
Here we can seprate only nos. but what can we do if we want alphabets
sepreately.
Help in this query.
Thanks in advance
Regards
LKModi
Dear All
if there is a coloum containg mix of nos and alphabets
like ram12
moh12345an
132shyam
we need only alphabets what can we do
like ram
mohan
shyam
Here we can seprate only nos. but what can we do if we want alphabets
sepreately.
Help in this query.
Thanks in advance
Regards
LKModi
Shyam,
"You are super hit", and this comment is something, which i am sure i
can give on your every solution
Keep posting such tips :)
Harpreet Gujral
On Mar 30, 5:23 pm, rf1234 rf1234 wrote:
> Dear All,
> Attached is the macro to extracting the numeric value from alphanumeric
> string.
>
Thanks Dave - that's excellent.
On Mar 30, 3:35 pm, Dave Bonallack wrote:
> Hi,
>
> Yes, it works; but it seems much longer than necessary.
>
> I think =MATCH(6,ATM!$C$3:$AJ$3,0) would work just as well.
>
> As to the Index part of the original function:
>
> When the Index function has a zero as
Hi Nike,
Maybe I do not see the problem, but let me focus on the solution...
Just select the columns or range of data cells and specify the cell
properties... special format e.g. mm/dd/ hh:mm or whatever you
preference is...
Good luck
Paul Willekens
--
---
Hi Abhidha,
Please specify what the result is you look for...
is it jdsdnc versus 2123 versus asdd ... or only extraction of the
number 2123 ?
is it iofruif versus 68732 versus fnw ... or simply 68732 ?
do digits appear separated by alphabetical characters on some
occasions or never?
As soon as I
Hi Mahesh,
First "expat" means "expatriate", a foreigner living and working
abroad... you probable mean "expert"...
It would be nice if you could append a couple of those text files and
the intended excel workbook, so we can see what you mean exactly...
Waiting to help you out, with kind regard
Sorry, Putta, but I need to correct my last mail:
In order to be get the "next row" in "Output", first go to that
sheet...
...
Dim lDone
...
'first find the new row in "Output"
Sheets("Output").Select
nRow = 1
lDone = False
While lDone = False
If Len(Cells(nRow, 1).Value) < 1 Then
lDone = T
Thanks for the reply, I had thought of this technique and got it to
work. I am only using a 2X5 array for this simple example, but my
actual array is much larger (actually I have two 100,000 X 8 arrays)
and I am trying to find a direct way to capture a range without
excessive programming. Also th
Hi Putta
A couple of lines added to determine the next row to fill...
Greetings
Paul Willekens
'===
Sub Normalize()
Dim cAddress
Dim cBusiness
Dim cCity
Dim cCompany
Dim cContact
Dim cState
Dim lDone
Dim nRow
'first find th
23 matches
Mail list logo