If you are a
regular user of Excel and deal with lot of text data, then mastering text
functions in Excel is crucial. Excel has in-built text functions to help
cleansing data for you. Below are some the text functions in excel helpful for quick
data cleansing
1.CLEAN: CLEAN function...
How to make any file read-only using VBA?
in VBA
with
No comments
VBA has in-built function SetAttr to change attribute of a
file or folder. This Function is classified as File or Directory function.
Below is the syntax of SetAttr and it takes two parameters.
Syntax: SetAttr (FilePath, Attribute)
FilePath is the fully qualified path of the file and
Attribute is the parameter of a file which you wish to change. In this example...
How to add line break and tab space in outlook using VBA?
in VBA
with
No comments
When working on email automation in Outlook, the content of the mail can be of type Body or HTMLBody. Depending on the type we select we can use html tags or VBA constants to add Line Break or Tab Space in the body of the mail.
Line Break:
Assume MailObj is the Outlook mail object. To add line break between two texts in the body of the mail we can use either VBA constant (vbCrLf) or html tag (<br/>)...
How to convert mailing list in Excel column into a string using Collections?
Let us assume you have say 20 email Ids in an Excel sheet to which a common mail communication is to be sent. One way of combining all the emails into a string is using CONCATENATE function. However it is difficult if the no. of email IDs to be combined are more. Another way to accomplish this is by using Collections in VBA. Collections are nothing but group of related objects.
First store all...
How to use curly braces in non-array formula in Excel
Curly Braces are generally used in array formulas in Excel. Array formulas are entered by pressing CONTROL+SHIFT+ENTER and Excel automatically inserts curly-braces in formula. Array formulas are useful when one has to get results from multiple set of values into a single cell or range of values.
Array Formula:
For example, Consider Range A1 through A3 has text "No", "Yes" and "None". If we have...