Friday, August 19, 2016

How to remove trailing spaces from cells in Microsoft Excel?

Sometime we may add unwanted spaces in Excel cells, which are not easy to find out but affect sorting, calculating, or others. This article will introduce several methods to remove trailing spaces after text strings of cells in Microsoft Excel.

arrow blue right bubble Remove trailing spaces from cells in Excel with VBA

Using the Trim function is easy to remove the trailing space in one cell, but time-consuming to remove trailing spaces in many cells. Here provides a macro to remove all trailing spaces of all cells in a selection.
Step 1: Select the range in which you want to remove trailing spaces from cells.
Step 2: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 3: Click Insert > Module, and paste the following macro in the Module Window.
Sub NoSpaces()
Dim c As Range
For Each c In Selection.Cells
c = Trim(c)
End Sub
Step 4: Press the F5 key to run this macro. And all of the trailing spaces of the selection will be removed.

arrow blue right bubble Remove trailing spaces from cells in Excel with Kutools for Excel

Maybe you are not familiar with Microsoft Excel's Macros, and need time to study it. Please do not worry about it. The second method is provided by a third-party add-in, Kutools for Excel. Its Remove Spaces tool can help you remove trailing spaces from cells quickly.
Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.
Step 1: Select the range in which you want to remove all trailing spaces from cells.
Step 2: Click the Kutools > Text Tools > Remove Spaces. See screenshot:
Step 3: In Remove Spaces dialog box, check the Trailing Spaces option in Spaces Type section. See screenshot:
Step 4: Click OK or Apply. And all the trailing spaces after the text string have been removed. See screenshot:
doc-remov-trailing-spaces3 -2 doc-remov-trailing-spaces4
Kutools for Excel's Remove Spaces tool makes it possible to delete all kinds of spaces from strings in cells, including all extra spaces, leading spaces, trailing spaces, or all spaces. Click to know more...

Saturday, August 13, 2016

The Save As dialog box appears two times when you try to save a file in Word 2010 or in Word 2007

When you click Save or Save As to save a file in Microsoft Word 2010 or in Microsoft Word 2007, the Save As dialog box appears two times.

Save as window appears twice
This problem occurs because the Normal.dotm template is corrupted.
To resolve this problem, create a new Normal.dotm file by changing the name of the old file. To do this, follow these steps: 
  1. Start Windows Explorer, type %appdata%\Microsoft\Templates in the address bar, and then press Enter.

    Templates folder
  2. Right-click Normal.dotm, and then click Rename.

    Normal.dotm file
  3. Change the file name to Normal.old.dotm.

    Changing to Normal.old.dotm
  4.  Restart Word. A Normal.dotm template is automatically generated.

    new template file
  5. Try to save a file to check whether the problem is resolved.


Wednesday, March 9, 2016

Count The Number of Cells With Specific Cell Color By Using VBA

Here the steps to create the count cell color UDF:

  1. Open Microsoft Excel then press Alt+F11 to show Visual Basic Editor window.
  2. On Insert menu, select Module to create a module. Then write the following script:
    Function CountCcolor(range_data As range, criteria As range) As Long
        Dim datax As range
        Dim xcolor As Long
    xcolor = criteria.Interior.ColorIndex
    For Each datax In range_data
        If datax.Interior.ColorIndex = xcolor Then
            CountCcolor = CountCcolor + 1
        End If
    Next datax
    End Function
  3. Close VBE window and back to Excel.
  4. To test the UDF, create some example data, or you can download this example file here.
  5. At cell D3, write the function: =CountCcolor(range_data,criteria)
    in range_data argumen, select cell C2 to C51
    in criteria argumen, select cell F1

  6. Press Enter and in cell F2 the result is 6. It means the number of cells with Blue cell color is 6 cells.

  7. You can also test another color. Change the color in cell F1 with any color you want from the data by using Format Painter to get same color.

  8. You can also pack the UDF, so that function can be used in another workbook and machine. Please following this steps :

    Step 1: Save The Workbook

    1. Fill the name that you want named to at the File Name box. Here I name it Count Cell Color.
    2. For the file type, choose Excel Add-In (.xlam) format.

      Note: You can save your Add-In file anywhere you want. But if you want it to be listed on Excel built-in, you should save it into the default location. On my computer with Windows 7 operating system, the default location for any versions of Microsoft Excel is: C:\Users\RADDINI\AppData\Roaming\Microsoft\AddIns

    Step 2: Install the Add-In
    1. Open Microsoft Excel on computer that you want install the Add-In. Open Add-Ins dialog box by clicking Add-In on the Developer tab.
    2. On the Add-In dialog box, click Browse button so Browse dialog box is displayed.

    3. Go to file location that Add-In file is saved. Choose the file and then click Open.
    4. On the Add-Ins dialog box make sure the add-in checkbox is unchecked. Then click OK.

Now the Count Cell Color UDF has installed and ready to use.


Monday, February 1, 2016

Engineering vs engineering technology

Engineering and engineering technology are separate but closely related professional areas that differ in:

  • Curricular Focus – Engineering programs often focus on theory and conceptual design, while engineering technology programs usually focus on application and implementation. Engineering programs typically require additional, higher-level mathematics, including multiple semesters of calculus and calculus-based theoretical science courses, while engineering technology programs typically focus on algebra, trigonometry, applied calculus, and other courses that are more practical than theoretical in nature.
  • Career Paths – Graduates from engineering programs are called engineers and often pursue entry-level work involving conceptual design or research and development. Many continue on to graduate-level work in engineering. Graduates of four-year engineering technology programs are called technologists, while graduates of two-year engineering technology programs are called technicians. These professionals are most likely to enter positions in sectors such as construction, manufacturing, product design, testing, or technical services and sales. Those who pursue further study often consider engineering, facilities management, or business administration.

There is much overlap between the fields. Engineers may pursue MBAs and open their own consulting firms, while technologists may spend their entire careers in design capacities.

For ABET accreditation, engineering and engineering technology programs are reviewed and accredited by two separate accreditation commissions, using two separate sets of accreditation criteria: the Engineering Accreditation Commission and the Engineering Technology Accreditation Commission.


What is the difference between engineering and engineering technology?

I spend quite a bit of time talking with prospective students and their families about engineering technology and the programs available here at NMU during their campus visit (see for more information about the campus visit program).  One topic I typically spend a lot of time on during these visits is the difference between engineering and engineering technology.  I look at it from 4 different perspectives; 1) Academically, how the classes and curriculum differ between the two types of programs, 2) Employment opportunities and types of work for each degree, 3) Registration as a Professional Engineer, and 4) What types of individuals are best suited for each type of program.  Each of these perspectives is expanded upon below.  Some universities offer both engineering and engineering technology (ET) degrees, and some universities offer either only engineering, or only ET.  Here at NMU we offer only the ET degree. 

The primary academic difference is that ET classes are typically more “hands-on” and more application focused than engineering classes.  Most ET classes will have labs associated with them in which the students apply the concepts learned in class to an actual application.  Some examples of classes that would typically be offered in an ET program that would not be found in an engineering program would be; basic manufacturing processes (machine shop), fluid power (hydraulics), and basic circuits (circuit board construction/soldering).  Engineering classes are typically more math intensive and theory based than ET classes.  A smaller percentage of engineering classes will have lab components.  Some examples of classes that are found in most engineering curriculums but not in many ET programs are; Calculus II and III, Differential Equations, and Chemistry II.  Another difference is the math used in the engineering classes is often calculus-based and algebra is used in most ET classes.

When I graduated from college I went to work as an engineer at a large automotive manufacturer.  At this company a significant differentiation was made between engineering graduates and ET graduates.  The ET students filled technician jobs.  They set up vehicles with instrumentation and actually took the vehicles out and did the testing, and depending upon their ability, did some data analysis.  The engineering students got jobs as project engineers.  They would specify what tests are done, assign the tasks to the technicians, analyze the data, write reports, and give presentations to management.  In talking with many of my colleagues that worked at other large companies, the job divisions and classifications were very similar to my experience.  Later in my career, I took a job at a small supplier (~600 employees) to the diesel engine industry.  At this company new employees were treated the same and got similar job assignments whether they had an engineering degree, or an ET degree.  In a number of cases ET degreed personnel moved into management positions and oversaw people with engineering degrees.  At this company you were assigned projects and moved up in the company based upon your job performance and the degree was irrelevant.  In my experience, and with discussions with many former NMU ET graduates, it seems that most smaller companies adapt this philosophy.

Another difference between engineering and ET degrees is the ability to get licensed as a professional engineer.  Registration as a professional engineer is required for engineers making final decisions that can have an impact on the health and welfare of the general public.  A large majority of the mechanical and electrical engineers across the country are not licensed professional engineers.  It is most common in the civil engineering disciplines.  Engineers working in the building design and consulting fields often find it beneficial to be licensed.  In Michigan the process to become licensed is; 1. Graduate from an accredited engineering program, 2. Pass the Fundamentals of Engineering Exam, 3. Work in industry for a minimum of 7 years under the guidance of a professional engineer, 4. Pass the Practice of Engineering Exam.  Notice the first step was to graduate from an engineering program.  An ET degree does not meet the requirements in Michigan.  Each state has their own specific requirements and procedure for obtaining licensure in that state.  About two thirds of the states, including Wisconsin, accept an ET degree from an accredited program as satisfying the formal education requirements.  Both the Mechanical Engineering Technology and Electronics Technology programs at NMU have been accredited by ABET, therefore meeting the initial requirements for professional engineer licensure in these states.  Accreditation means that an independent evaluation of the program was done and the program was approved as having met the requirements of the accrediting body.  Engineering and ET programs in the US are accredited by ABET (   Therefore, in the majority of states, whether you have an engineering or an ET degree has no impact on your ability to become licensed as a professional engineer.

The last perspective I usually review is that of the student.  What type of individual is best suited for each degree?  In general, those most suited for the ET program are the “hands-on” type of individual.  This may be the student who took small engines, or machine shop in high school, or the person who likes tinkering on their snowmobile or dirt bike on the weekends.  The very academic student, the one who took AP calculus in high school, who gets a 28 or 29 on the ACT, and who would rather mess around on their computer than mess around in the garage, may find an appropriate fit in an engineering degree program.

Hopefully this has been a helpful summary of some of the differences between engineering and engineering technology.  If you have any questions about these differences or anything else related to the programs offered here at NMU, feel free to contact me at my direct office line (906-227-1179), or even better, plan a visit to NMU by contacting the campus visit office (906-227-1709) and you will be get an appointment to talk directly with myself or one of my colleagues.  No matter what your decision, you are exploring a degree program that will serve you well and provide yourself a gainful career.  Good luck in your education!!

Sunday, January 31, 2016

Macro to Split the Mail Merged Letters

Recently I came across this issue in my project. In our testing project, we follow a different Defect Management tool and the Development comapny using a different defect management system. Our tool can give all the defects in a Excel sheet. But the other party needs each individual defect in a single word file in their template.

So we got their template. And I have checked whether we have all the necessary fields in our excel file to fit in their Word Template. Except one field almost every items like Defect Description, Tester Name, Testd Date etc. So i used the mail merge option in Word and used the excel file as data source. Fitted in the necessary fields from Excel in the Word file. Used the mail merge wizard and generated all the defects in their template as a continuous document. But the developers need them in a separate files as incident logs. So i was searching for the options to split the files in MS Word itself. But there is no way. So i wanted to try the macro program. Fortunately i got my solution in The wollowing macro written by someone saved me a lot of time. I have created a new macro to my consolidated letters document and pasted the below macro program and tinkered a little bit to change the folder name (where to store the splitted files) and File name (name for my splitted files). Then I ran the macro, it did the magic of separating the consolidated files to separated files... Try it when u face this sort of solution.... Thanks to

Sub Split()
Dim mask As String
Selection.EndKey Unit:=wdStory
Letters = Selection.Information(wdActiveEndSectionNumber)
mask = "ddMMyy"
Selection.HomeKey Unit:=wdStory
Counter = 1
While Counter <> DocName = "C:\" & Format(Date, mask) & "_Letter_" & LTrim$(Str$(Counter)) & ".doc"
With Selection
Unit:=wdCharacter, Count:=1
.Delete Unit:=wdCharacter, Count:=1
End With
ActiveDocument.SaveAs FileName:=DocName, FileFormat:=wdFormatDocument
Counter = Counter + 1
End Sub

Blogger Tips And Tricks|Latest Tips For Bloggers Free Backlinks