Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Using web recorder in power automate desktop -
It is official not by me ... but you can even check online
-
Rename Files in Power automate desktop by reading names from excel worksheet #rpa
-
VBA Tutorial 15 Count & Sum during loop
Saurabh Jain posted a blog entry in VBA Macros - Excel Programing's Tutorials
Learn how to count, sum and display running totals -
-
Want to add a line break in between each text string? This is done by entering the CHAR( ) function in between each text string/argument. CHAR function returns a character specified by a number from 1 to 255. For example, CHAR(10) returns a line break in windows, CHAR(34) returns a ” (double quote), CHAR(64) returns @, etc. So, by simply adding CHAR(10) in between your formula you can enter a line break. You will need to select WRAP TEXT in order to see each text on a separate line.
-
You already know that you need a line between the strings u need to add line in between Line with come with char(10)
-
In this tutorial we will learn to send dynamic email to users listed in excel using power automate desktop An example of Robotic process automation
-
VBA Tutorial 14 : For loop examples to read data write data & transform data
-
-
You need to extract postal code in a different column and then it can be applied
-
VBA Tutorial 13 : For next Loop
Saurabh Jain posted a blog entry in VBA Macros - Excel Programing's Tutorials
Download VBA code -
-
-
Download code file
-
New Logo Old Logo
-
VBA Tutorial 11 InputBox & Message Box
Saurabh Jain posted a blog entry in VBA Macros - Excel Programing's Tutorials
Download -
-
-
VBA Tutorial 9 : Data Types and Variables
Saurabh Jain posted a blog entry in VBA Macros - Excel Programing's Tutorials
We will learn Storing data in variables Reading data from variables Calculations in variables Download macro enabled workbook -
-
-
Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
