Anil Nahar - Advance Excel Formula (For all users) Ready to use Customize Function

Disclaimer

Ready to Use Powerful Excel VBA Code (Part 2) Customize Function is anindependent publication and is not affiliated with, nor has it been authorized,sponsored, or otherwise approved by Microsoft Corporation.

Trademarks

Microsoft, Visual Basic, Excel and Windows are either registered trademarks ortrademarks of Microsoft Corporation in the United States and/or other countries.

Liability

The purpose of this book is to provide basic guideline for people interested in ExcelVBA programming. Collection of ready code has been used on reality platform bytechnical and non technical users on their routine. Although every effort and care hasbeen taken to make the information as accurate as possible, the author shall not beliable for any error, harm or damage arising from using the instructions given in thisbook.
All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, without permission in writing from the author.

Acknowledgement

I would like to express my sincere gratitude to many people and Excel LearningWebsites who have made their contributions in one way or another to the successfulpublication of this book.
My special thanks go to my Parents and Gurudev (Acharya Sh Ramesh) and friendMr. Rakesh Jain (Charvi Associates) having expert knowledge of web programming& My Accounts, HR, IT & ERP Departments Colleaguecontributed their ideas andeven wrote some of the sample programs for this book. I would also like toappreciate the support provided by my beloved wife Manisha Jain, son MasterSamkit and youngest daughter Samiksha Jain and Friends.
I would also like to thank the millions of visitors to my Smart Excel & Learningwebsite at http://www.anilnahar.com l for their support and encouragement.

About the Author

Anil Nahar holds a Master degree inComputer Application (MCA), a Bachelordegree in Commerce (B.Com.) and Three year completed C.A. trainingby ICAI (Institute of Chartered Accountant of India). He is working on real platform with aesteem organization on Functional as well as Technical Support in Excel. He isprovided many smart excel training programmes in corporate and appreciated bymanagement.He has been involved in programming for more than 10 years. Hecreated the popular online Smart Learning Tricks Tutorial at www.anilnahar.com in2017 and since then the web site has attracted millions of visitors and it is one of thetop searched VBA Excel websites in many search engines including Google.

Ready to Use 101 Powerful Excel VBA CodeJust Copy - Paste - Run(For Functional Users)

Contents

User-Defined Functions

Excel having large collection of functions in-built . Mostly those functions aresufficient to complete the work. Sometimes, Excel doesnt have a pre-built functionthat suits a specific need, Well not to worry about it , you can create your ownfunction called User Defined Function or custom Excel function with help ofVisual Basic for Applications (VBA). You can access a User Defined Function any time just like any other Excel function.
But the main problem is you should have good knowledge of Excel VBAProgramming and need so much time to writing code as desire.
This book helps you to use ready code by just copy paste and enjoy the work.Benefits of this books :
Available readymade function which is very unique and rare.Create new formula in easy way instead of using long formulaWithout any technical knowledge use the new functionImpress your boss with fast workingEarn 10000$ per month by making new project with help of my other book Ready to Use 101 Powerful Excel VBA Code
Lets know how to use User define function :
The following steps can be used to create UDFs:
1. Open up a new workbook.
2. Open the Visual Basic Editor by pressing Alt+F11.3. Insert a new module.
4. Copy and Paste the code that makes up the UDF
5. Press Alt+Q to exit the Visual Basic Editor (VBA)
6. Use the function - They will appear in the Paste Function dialog box (Shift+F3)under the "User Defined" category
If you want to use a UDF in more than one workbook, you can save your functions inyour own custom add-in. Simply save the Excel file that contains your VBA functions as an add-in file (.xla). Then load the add-in (click Tools then Add-Ins...).
Awareness: Be careful about using custom functions in spreadsheets that you needto share with others. If they don't have your add-in, the functions will not work whenthey use the Worksheet.

Text to Column of Cell value by Separator

Function : = TTC($A$11, " ", B2)
Ready Code :

Extract Bold Value From a Cell

Function : = BoldText(A2)

Reverse the Cell Text

Reverse Text Function : = reverse(A2)

Find Factorial Number

36 Function : = reverse(A2)

Merging Cell value by Separator i.e. Concatenate

Function : = concat(A2:C2)