Excel UDF Functions
First Word Last Word
These 2 UDF’s will extract the first and last words using a formula in your worksheet. It is worth noting that during a...
|Category Archives: Excel UDF Functions
Excel UDF Functions
UDF Choose csv file from dialog box
This UDF opens up the dialog box to choose a file to import into an Excel woorkbook. Function GetFile() As String Dim filename__path...
|
Excel UDF Functions
UDF Get the comments from a cell
Comments in Excel can be stored in a cell and their locations are identified by a small red triangle in the top right...
Leave a comment |
17
Nov
Current Projects, Excel UDF Functions, VBA Examples and reference
Import csv file and export in batches of 1000
This recent project assigned to datanology’s VBA team required a regular import of a standard csv file that was created from a web...
Leave a comment |
Excel UDF Functions, VBA Examples and reference
Splitting and Moving data with VBA
Splitting data can be a cumbersome and highly manual task, and could result in inaccurate data. Splitting data, moving it about and intelligently...
2 Comments |
Excel UDF Functions
Excel UDF Get the colour of the cell
Dealing with colours jn Excel became a lot more important when Office 2010 was released. Conditional formatting allowed for large ranges of slightly...
1 Comment |
Excel UDF Functions
Excel UDF Get Workbook name
In Excel there is no built in function to check and return a result for the workbooks name. Even though it may be...
Leave a comment |
Excel UDF Functions
Excel UDF Get Worksheet name
In Excel there is no built in function to check and return a result for the worksheets name. Even though it may be...
Leave a comment |
Excel UDF Functions
Excel UDF Identify email address
We carry out a lot of work on document and data cleansing, data capture and data blending. One of the most common request...
Leave a comment |
Excel UDF Functions
Extract a specific length of numbers from a string
Recently we have been asked to provide a solution for a client who was faced with potentially thousands of cells in a range...
Leave a comment |
Excel UDF Functions
UDF to locate first letter in string
In the process of data manipulation, data cleansing for instance it is a regular occurrence to identify a structure of the string in...
Leave a comment |
Excel UDF Functions
UDF Extract all comments from a cell
This UDF (User defined function) is designed to be pasted into a VB Module (ALT + F11) and will then become a normal...
Leave a comment |
Excel UDF Functions
Excel UDF to validate UK Postcode
As part of our postcode analysis and cleansing processes, an important task is to ensure that a given postcode is actually a valid...
5 Comments |
