Your Online Success Partner
Inevitably, when you import information into Excel you will need to separate a cell’s contents into two columns. Let’s say you have imported a list of addresses but you need to separate the first and last names so you can use them in a mail merge letter.
Step 1: Highlight the cells containing the information you wish to separate
Step 2: Go to Data | Text To Columns. In Excel 2007, click the …
[Read more...]
I don't know about you but sometimes spell check drives me crazy!! As a web designer it is rare that I type a document that doesn't include a web address somewhere. And there goes spell checker underlining each one with that annoying red sqiggle, even in my email (Outlook) and password logs (Excel)!
Well no longer! I put my foot down and have banished this particular annoyance from my …
[Read more...]
Move Table Rows Up Or Down
This tip is probably most useful when you're working in a table, although you can use it to reorder paragraphs outside a table, too. Let's say you decide you want the third row of a table to be the top row. Just click within the third row, hold down [Alt][Shift] and press the up arrow key twice. Each time you press the arrow key, Word will move the row up one. You can …
[Read more...]
Create a new column for the combined data. Select a cell in that column. Click on the Insert menu across the top of the screen and choose Function.
In the Function Menu choose All for the Function category. In the Function name box, highlight any name and start typing CONCAT. Highlight the concatenate function and click the OK button.
(In Excel 2007 you will find the functions when you click on …
[Read more...]
If you are like me you keep track of lots of different data for various clients in Excel spreadsheets. To save time I have setup most of my spreadsheets to automatically update information between sheets when ever possible. This keeps me from having to manually enter data in multiple spreadsheets. This both saves time and eliminates typos.
Simply highlight the cell you want copied and click copy. …
[Read more...]
As I a sure you have noticed when you copy from one document into a Word document, the pasted text retains its original format. In Word 2003 you could customize (or turn off) the Smart Tag feature which let you change the format of the pasted text to either plain text or the matching format of the Word document. That was better than manually formatting the text but you still had to set the Smart …
[Read more...]
Build A Powerful Mailing List of People Ready and Eager To Buy... From YOU!
A responsive, active, email list that READS your emails and takes immediate action!
It’s not as hard as you think! Click Here to learn how with ebook and MP3!
