![weird-error-on-MSword.jpg](/assets_c/2008/12/weird%20error%20on%20MSword-thumb-200x150.jpg)
Well, its actually a MS Word error, but i wonder how i got it. "Word has encountered a problem and cannot exit", i know Word has this background task when trying to close an application but i really find the message stupid.
The merge and Center button in Excel only centers the top left text and deletes the rest. What if the two columns of First names and last names are to be merged into the format: Last name, First name it would then become a problem.
Using the Ampersand ( & ) operator, it allows us to merge cells in an excel worksheet. you can create a formula to merge cells in excel or just insert it right away on the cell formula bar.
Problem:
And you wish to merge the two cells at A1 and A2 to the cell at A3
Given:
Cell A1 has the text "Lastname"
Cell A2 has the text "Firstname"
Solution:
* First position your active cell on A3.
* On the formula bar input the following: =A1&A2 [ENTER]
It should display LastnameFirstname on cell A3
To add a space and a comma, use the following:
=A1&", "&A2
it will output: Lastname, Firstname
alternatively you can also use the concatenate function, like this:
=CONCATENATE(A1,", ",A2)
Test the Code
Option Explicit Sub DeleteDups() Dim x As Long Dim LastRow As Long LastRow = Range("A65536").End(xlUp).Row For x = LastRow To 1 Step -1 If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then Range("A" & x).EntireRow.Delete End If Next x End Sub
Creating a hyperlink in excel is simple. Notice that after typing any uri in excel the text automatically turned into a hyperlink. You can add any link as you like in excel as long as there is a prepended http:// phrase before the text entered.
Now, what if we are going to add a dynamic URL? It would be best explained by example, so here it goes.
For example: We are asked to check multiple sites for the following internet standards; W3C HTML Validator and WDG HTML Validator.
We have a reference cell A1 have the text https://tildemark.com. We all know the URL for the respective standards as:
W3C - http://validator.w3.org/check?uri=https://tildemark.com
WDG - http://www.htmlhelp.com/cgi-bin/validate.cgi?url=https://tildemark.com&warnings=yes
Now, all we need to create an entry such that each time we change the domain names the entry on each validator also changes.
Do the following on Excel:
Cell A1 - https://tildemark.com
A | B | |
---|---|---|
1 | https://tildemark.com | |
2 | ||
3 | ||
4 | ||
5 | ||
... | ||
9 | =HYPERLINK ("http://validator.w3.org/check?uri="&A1,"Check W3C HTML Validator") |
|
10 |
=HYPERLINK |
More info at Office Website.
Removing a bunch of hyperlinks can be tedious. imagine the time you have to right-click on each of those links and selecting 'remove hyperlink' on the context menu. Of course it would just take two clicks, but what if you are to remove a hundred of them or perhaps 1000 of them? I'm sure that would scrape out the paint of your right-mouse button. :)
I have some simple techniques you can use in order to remove multiple hyperlinks on a page:
Removing just one hyperlink
1. Right-Click on the cell and select Remove Hyperlink on the context menu.
Removing the cell format
1. Select the cells having hyperlinks. You can use CTRL+LEFT CLICK to randomly select a cell.
2. On the menu click on Edit. Hover your mouse to the option Clear and select Fomats. Please note that the cell is still clickable to remove the hyperlink completely you have to select Clear->All.
Remove hyperlink on selected cells the better way
1. Type in any text or number in a blank cell
2. Right-click and select Copy on the context menu.
3. While pressing CTRL, select each hyperlink you wish to be removed
4. On the Edit menu, select Paste Special.
5. Under Operation, click Multiply and then click OK.
Removing using a macro
Assuming you know excel programming you could create a macro to automatically remove the hyperlinks.
1. Start Visual Basic Editor. Alternatively you can press ALT-F11 to start the editor.
2. Double click the workbook you are using on the Project Explorer.
3. Type the following text:
Somebody installed a new software to my pc which sets the default program for my .jpg files. the icon were not functioning as usual and displays an error message whenever i try to open a jpg image. thanks a lot to this website i have found which gives the solution to reset the file association back to its default application, the Picture and Fax Viewer of the Windows XP OS.
just download this text and merge or (double click it) to your registry file to fix the association of files.
You can now download your Yahoo emails locally using POP3 to any email client you are using, i use MS Outlook 2003. First we need to install a program called YPOPs configure the program and your client then its done.
We all know that there is no POP3 and SMTP support from Yahoo free mails unlike gmail we can configure our client to download mails from the gmail server and send files using gmail SMTP. With the help of this wonderful program, we can now download all emails from the Yahoo server.
1) Download the latest version here.
2) Install the program.
3) Configure it by clicking on the program icon at the tray
4) Configure your mail clients. Use 127.0.0.1 for your SMTP Server and 127.0.0.1 for your POP3 Server.
5) Download mails.