• Excel Business Solutions
  • VBA Solutions
  • Data Capture & Data Grabbing
  • Blog
  • Shop
DatanologyDatanology
  • Login
  • Basket / £0.00
    0

    No products in the basket.

  • Home
  • Excel Business Solutions
  • VBA Solutions
  • Data Capture & Data Grabbing
  • Services
    • Data Analysis
    • Data Capture & Data Grabbing
    • Data Entry
    • Data Blending
    • Bespoke CRM Databases
    • Data Cleansing
    • Data Consultation
  • Recent Projects
  • Shop
  • Contact

Category Archives: Excel UDF Functions

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...

| 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 text
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...

| Tagged Choose file in excel, choose file to import in excel UDF, UDF to choose file
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 | Tagged export excel comments, find comments, get comments, udf get the comments in excel
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 | 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 excel
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 | 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 surname
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 | 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 colour
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 | Tagged Excel get workbook name, how do i get the workbook name in excel, UDF workbook name, UDF workbook name excel, workbook name
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 | Tagged excel VBA worksheet name, Excel worksheet name, get worksheet name, how do i get the worksheet name, UDF worksheet name, what is worksheet name
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 | Tagged email grabber, Excel find email, grab email address, identify email address, UDF email address
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 | 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 cell
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 | Tagged excel find first letter, excel first letter, excel UDF find first letter, find first letter, UDF first letter
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 | Tagged excel comments to text, Excel get comments, extract excel comments, get comments UDF, how do you get comment text
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 | 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

Search

Recent Posts

  • 27 Dec
    VBA to check if any cells on the row have a colour
    Leave a comment
  • 06 Dec
    First Word Last Word
    Leave a comment
  • 21 Jul
    Create_PDF
    Leave a comment
  • 31 May
    Check if cell is a number
    Leave a comment
  • 21 Apr
    Identify if cell is coloured by conditional formatting in VBA
    Leave a comment

Products

  • VBA Automation VBA Data automation £35.00
  • Excel Database Create an instant Excel Database with Search and reports
    Rated 5.00 out of 5
    £75.00
  • Excel Formula Product Provide you with the Excel formula you require £15.00
  • Excel Consultation Excel Consultation £35.00
  • Shop
  • Terms & Conditions
  • Contact Datanology
'datanology' (ˈdeɪtəˈnɒlədʒi) - 'the application of a dataset(s) to any number of modern technologies in order to maximise the potential commercial value of the information available.

Website Design and SEO by The Web Designer Group

the webdesigner group

Close Button

This Website has been designed and developed by

The Web Designer Group

Website Design
twdg
Google Optimised Website
twdg
Secure & Safe Website Design
twdg
Web Design Services UK
  • Home
  • Excel Business Solutions
  • VBA Solutions
  • Data Capture & Data Grabbing
  • Services
    • Data Analysis
    • Data Capture & Data Grabbing
    • Data Entry
    • Data Blending
    • Bespoke CRM Databases
    • Data Cleansing
    • Data Consultation
  • Recent Projects
  • Shop
  • Contact
  • Login
  • Excel Business Solutions
  • VBA Solutions
  • Data Capture & Data Grabbing
  • Blog
  • Shop