Archive for the ‘Business Tips’ Category

There may be times when you find yourself needing to separate a first and last name that are together into two separate columns.  Here is a quick and easy way to do this:

Note: Only do this if there is only a first and last name no middle initial, prefix, or Jr. Sr in the cells

Make sure there is a blank column beside the name

Highlight the cell or cells that you want to separate

Go to data on the toolbar>select text to columns

A box appears

Select fixed width>next

Click next on the next window

At the next window select finish

There you have it, instead of first and last name in one cell, they are now in two different cells.

Next week we will discuss separating names that have middle initials or middle names

Bookmarks

Tweet This Post 

How many times have you been trying to create a document or a table in Microsoft word and it automatically does a page break at the worst time?  Chances are you already know this but just in case here is a quick way to fix that:

Put your cursor where you want the page break to be then click>insert>break

A little box will pop up asking what kind of break you want select>page and click okay.

There you have it, a page break where you want it instead of where Microsoft wants to put it.

Bookmarks

Tweet This Post 

When participating in online forums/groups, it is important to include a signature line. A signature line should (at the very least) include your name, your business name, website and blog URL. To make a link clickable always include the http:// at the beginning of the URL.

Also, don’t overdue the signature line because if you do, the important stuff will be overlooked and people will get annoyed.

Bookmarks

Tweet This Post 

When online networking, it is important to post a little something on their wall, guestbook, etc. It helps open a dialogue between you and your connections so here’s a tip so that you don’t scare what could be a very important connection away:

When signing guestbooks, walls, etc it is about them, not you.  Say something nice about their interests, their websites whatever just make it about them.  That means no signature lines, no sales pitches and no website links unless it is not related to your business and based on their interests, you feel they could benefit from it.

Bookmarks

Tweet This Post 

You have a spreadsheet and the first and last name are in their own cells but you would prefer them to be in a cell together but you don’t want to retype them all again.  Here is a simple solution:

Assuming you are using Column A and Column B:

Insert an empty column after column B (Highlight the next column>Click Insert>Column

Highlight the first cell in the empty column

At the top of the screen there is an area that is a formula bar

In the formula bar type the following: =A1&” “&B1

Click Enter

There you have it, the names are now combined.

To do this to the entire spreadsheet:

Highlight the cell of the combined names

Hold Shift>down arrow key

Highlight as far as you would like to go

Click>Edit>Fill>Down

There you have it, the whole spreadsheet now has the names combined.

Bookmarks

Tweet This Post