Friday, August 1, 2008
Concatenate Implementation
In this post, you will see guidance how to apply concatenate function.
Because animation picture are a little big (800kb), so you must click Readmore link below. It will directing you to full post.
Click button below to play the video:
Last name formula (to extract last name from full name):
=LEFT(A18,FIND(",",A18,1)-1)
First name formula (to extract first name from full name):
=MID(A18,FIND(",",A18,1)+1,LEN(A18)-FIND(",",A18,1))
Couple name formula (to join both first name with same last name):
=IF(B18=B19,CONCATENATE(C18," & ",C19, " ",B18),"")
Lock Cells with Button and Macro
In this post, you will see guidance how to lock cells using button control panel and macro.
Because animation picture are a little big (600kb), so you must click Readmore link below. It will directing you to full post.
The code are: (from Jim Gordon)
Sub LockemUp()
' LockemUp Macro
' Macro recorded 7/30/2008
Cells.Select
Selection.Locked = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Thursday, July 31, 2008
Subscribe to:
Posts (Atom)
