$$Excel-Macros$$ Re: Parse data from Notepad to Excel: Help

Hi, better to use "Selection.TextToColumns" with text then use "Selection.Copy" and "Selection.PasteSpecial Transpose:=True" Sincerely, ASD 2008/10/1 FF <[EMAIL PROTECTED]> > > Hi, > I am trying to parse data from notepad to excel using VBA macro. > A, B, C > Field4 = 8.2 > Field5 = 6.7 > Field

$$Excel-Macros$$ Re: VBA Macro Excel Add Text In Cell

Hi, You can try the following VBA code. Sincerely , ASD * * * Sub PutPeriods() Dim lpString As String Dim lpActiveString As String Dim iCount As Integer lpString = Space(2) & Trim(ActiveCell) lpActiveString = "" For iCount = 1 To Len(lpString) Step 1 If iCount Mod 3 <> 0 Then lpActiveString =

$$Excel-Macros$$ Re: HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

Hi Augustine, You can use "=DAYS360(Start_date,End_date)/360" Good Luck, ASD 2008/10/6 Augustine <[EMAIL PROTECTED]> Hi everybody, I tried using the DateDif function in Ms-Office 2007 but its not working. Is there any other way to activate the function since i heard that the f