Fill blank cells with value above in Excel

http://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html

Blogspot Ownership Transfer

http://blogging.nitecruzr.net/2007/06/how-to-transfer-blog-from-one-account.html

Converter - VOB to MPEG

Free software website:-
http://www.asoftwareplus.com/

Nice link for free VOB to MPEG converter.

Thanks.

URL: http://www.asoftwareplus.com/vob-to-mpeg-converter-download.html

痘痘位置反應健康狀態

Create Show Desktop Icon

1. Copy below code and paste into notepad.

[Shell]
Command=2
IconFile=explorer.exe,3
[Taskbar]
Command=ToggleDesktop

2. Save this notepad as "Show desktop.scf".

3. An show desktop icon will appear.

English Words - Others

English	Same Meaning	Meaning
grave issue	serious	重大問題
taken lightly	ignore
contributing factors
lead to/bring about	cause	menyebatkan
in the long run		jangka masa panjang
over here		mai sini
on the rise		meningkat
in short		总之
emulate		mencontohi
déjà vu		似曾相识
Likewise		同样
explicit		外在的
implicit		内含的; 固有的
somehow		不知何故
Comprehensive		全面

English Conversation

English	Meaning
Are you out of your mind?	Are you crazy?
A: he is in hospital. B: he is?
How has life been treating you or should i say, how have you been treating life?
I hope that you are in the pink of health / as fit as the fiddle.
I couldn't be better.
Let me apologize for the long silence.
if you insist	if you request to
A: Thank You. B: Don't mention.

English Words - Noun

English	Same Meaning	Meaning
fiancee		未婚妻
fiance		未婚夫

Password Protect Excel File

http://answers.yahoo.com/question/index?qid=20070605124037AAgHGk8

The way to password protect an Excel file:
- Open the file
- File - Save As
- In the Save As box, Click "Tools" on the right hand side
- Select "General Options..."
- You can set a password to Open it, or just to modify it (i.e. anyone can open as read-only, but need password to modify)

How to Compare Data in Excel

http://www.wikihow.com/Compare-Data-in-Excel

“=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)”.

=ROUND(B757,0)-ROUND(J757,0)

German Vocabulary

German	Pronounce	Meaning
Ich	eekz4	I
Sie	siez3	You, She, They, Them
er	a1r3	He
wir	will2	We
Hallo	Ha1low3	Hello
guten Morgen	guden mogen	Good Morning
guten Tag	guden2 tag4	Good Afternoon
guten Abend	gud3 na3 ben3z	Good Evening
gute Nacht	gud3 te1 naf4z	Good Night
Entschuldigen Sie	En1 sure1 D N Zi3	Excuse me
ja	gia3 ~ ya3	Yes
nicht	nif4tz	No
danke	dang4 ke3	Thank You

German Conversation

German	Pronounce	Meaning
Sprechen Sie Englisch?	Su3 prise4 'zen3 Si3 English	Do you speak English?

German	Meaning
Ich	I
Sie	You
	Nice to meet you.
Anata wa Amerika-jin desu ka.	Are you an American?
Nihon-jin desu.	I am Japanese.
Anata wa daigaku-sei desu ka.	Are you a college student?
Watashi wa kookoo-sei desu.	I am a high school student.

German Useful Link

http://www.germanlanguageguide.com/

http://www.dummies.com/how-to/content/common-conversational-words-and-phrases-in-german.html

http://www.dummies.com/how-to/education-languages/languages-cultures/german.html

http://www.speakgerman.co.uk/phrases/basic_phrases (voice)

Ms Excel - String Function

This is to extract partial of text that embeded in cell.


(A) String with not fixed character number

Data Used:

Fruit List
25 Building A 25Mar2010
26 Building B 26Mar2010
27 Building C 26Apr2010
28 Building D 05Sep2010
29 Building E 09Jan2010

Formula Used:

Text = "25 Building A 25Mar2010"

Partial of String
"25" = LEFT(Text,2)
"Building A" = MID(Text,4,10) ~ =MID(TEXT,start_num,num_chars)
"25Mar2010" = RIGHT(Text,9)

First & Last Character/Digit
"2" = LEFT(Text)
"0" = RIGHT(Text)


*Replace Text with the data cell

String_1

(B) String with not fixed character numberRetrieve Text before or after "Spacing"

Data Used:

TIENWAH Final Divddend 12.05 Sen
FABER Final dividend 6% Less Tax
LEADER First lntenm Dividend 1:5 Sen Less Tax
APM Final Dividend 10% Less 25% Tax
HUPsENG Final Dividend 4 Sen Single Tier

Formula Used:

A2 = "TIENWAH Final Divddend 12.05 Sen"

"TIENWAH" = LEFT(A2,IF(ISERROR(FIND(" ",A2,1)),LEN(A2),FIND(" ",A2,1)-1))
"Final Divddend 12.05 Sen" =RIGHT(A2,LEN(A2)-1-(IF(ISERROR(FIND(" ",A2,1)),LEN(A2),FIND(" ",A2,1)-1)))

Search location of first "Space"

8 = FIND(" ",A2,1) ~ =FIND(find_text,within_text,[start_num])

String_2

URL: Save time by using Excel's Left, Right, and Mid string functions
RIGHT, RIGHTB
Removing the last two characters from a stringExtracting First And Last Names

Ms Excel - Hyperlink not function

Excel hyperlink not able to function.

Error Message:

"The operation has been canceled due to restrictions in effect on this computer"

Solution 1: Reset IE setting

IE-> Tools->Internet Options.
Program tab.
Under 'Default web browser, make sure 'Make default' had been choosen. (so that IE is the default browser.
Restart system.

Solution 2: Edit Registry

If solution 1 can't work, try below steps.

If you received this error after uninstalling any application that takes over the HTML open command (including, but not limited to, Chrome & Firefox browsers) you may also need to change the HTM/HTML association in the registry.

1.Start, click Run, type Regedit in the Open box, and then click OK.
2.Browse to HKEY_CURRENT_USER\Software\Classes\.html
3.Right click the value for the .html key and select Modify…
4.Change the value from “ChromeHTML” to “htmlfile” (or from FireFoxHTML to htmlfile)
5.Repeat for .htm, shtml, .xht, .xhtml, .xhtm keys

Repeat these steps for htm and .shtml keys if they exist. You may also want to check the xhtml and xhtm keys. Don’t want to edit the registry? Download this file (right click and choose Save target as…) Then double click on the file to run. From After uninstalling Google Chrome Links in e-mail don’t work any more

URL: http://www.slipstick.com/problems/this-operation-has-been-cancelled-due-to-restrictions/#reg2