No products in the basket.
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...
|These 2 UDF’s will extract the first and last words using a formula in your worksheet. It is worth noting that during a...
| Tagged 1st word, extract first word, extract last word, First word, first word in a text string, first word last word, get the 1st and last word, get the first and last word, last word, last word in textThis UDF opens up the dialog box to choose a file to import into an Excel woorkbook. Function GetFile() As String Dim filename__path...
| Tagged Choose file in excel, choose file to import in excel UDF, UDF to choose fileComments 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 | Tagged export excel comments, find comments, get comments, udf get the comments in excelThis 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 | Tagged concatenate date and time, export multiple csv, export to multiple csv files, import csv file to excel, import to excel, UDF import csv, UDF to import csv file to excelSplitting data can be a cumbersome and highly manual task, and could result in inaccurate data. Splitting data, moving it about and intelligently...
2 Comments | Tagged data split, excel move data, excel split data, Split data vba, split first name surname, split forename and surname, split names, UDF, UDF first word, UDF last word, vba split forename and surnameDealing with colours jn Excel became a lot more important when Office 2010 was released. Conditional formatting allowed for large ranges of slightly...
1 Comment | Tagged cell color, Excel cell colour, Excel color of cell, Excel colour of cell, how do i get the colour of a cell in excel, UDF cell colourIn 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 | Tagged Excel get workbook name, how do i get the workbook name in excel, UDF workbook name, UDF workbook name excel, workbook nameIn 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 | Tagged excel VBA worksheet name, Excel worksheet name, get worksheet name, how do i get the worksheet name, UDF worksheet name, what is worksheet nameWe 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 | Tagged email grabber, Excel find email, grab email address, identify email address, UDF email addressRecently 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 | Tagged extract 6 numbers vba, extract numbers from a string, Extract specific length number from a string, udf extract numbers, UDF get specific length of numbers from a cellIn 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 | Tagged excel find first letter, excel first letter, excel UDF find first letter, find first letter, UDF first letterThis UDF (User defined function) is designed to be pasted into a VB Module (ALT + F11) and will then become a normal...
Leave a comment | Tagged excel comments to text, Excel get comments, extract excel comments, get comments UDF, how do you get comment textAs part of our postcode analysis and cleansing processes, an important task is to ensure that a given postcode is actually a valid...
5 Comments | Tagged Excel postcode, get uk postcode, invalid postcode, postcode UDF, postcode validation, UDF postcode, UK postcode database, UK postcode validation, valid postcode, validate a postcode in excel, validate UK postcode