Diary of a Tech Guy

Hi Guys! I just wanted to share with you this tutorial about separating names. This applies to Microsoft Excel 2003 and 2002.

Split content based on a delimiter

This method works best if your names have a similar format, such as “First_name Last_name” (where the space is the delimiter) or “Last_name, First_name” (where the comma is the delimiter).

• Select the range of data that you want to convert.
• On the Data menu, click Text to Columns.
• In Step 1 of the Convert Text to Columns Wizard, click Delimited and then click Next.
• In Step 2, select the Space check box and then clear the other check boxes in the Delimiters section.

The Data preview window shows the first and last names in two separate lists.

Note If your list contains middle names, the full name will be distributed into three separate columns: first, middle, and last.

• Click Next.
• In Step 3, click a column in the Data preview window, and then click Textunder Column data format.
• Repeat this step for each column in the Data preview window.
• If you want to show the separated content in the columns next to the full name, click the icon at the right of the Destination box, and then select the cell next to the first name in the list (B2, in this example).

• 1. Important If you do not specify a new destination for the new columns, the divided data will replace the combined data.

• 1. Click the icon at the right of the Convert Text to Columns Wizard.

• Click Finish

How to increase Virtual Memory?

In Windows XP

1.Click Start, and then click Control Panel.
2.Click Performance and Maintenance, and then click System.
3.On the Advanced tab, under Performance, click Settings.
4.On the Advanced tab, under Virtual memory, click Change.
5.Under Drive [Volume Label], click the drive that contains the paging file that you want to change.
6.Under Paging file size for selected drive, click to Custom size check box. You can enter the amount of memory you would like to reserve for Virtual memory by entering the initial and maximum size.
7.Click Set
When you are prompted to restart the computer, click Yes.
Special Note: You should choose the same amount for the initial size and maximum size. This will Stop your CPU from constantly changing the paging file.

continue reading…