Tracy van der Schyff

Facilitating The Evolution of Human Capabilities



Day 327 – Using CONCAT and TEXTJOIN in Microsoft Excel

 #Office365Challenge I've always been a huge fan of data clean-up formulas. LEFT, MID, RIGHT, TRIM, CONCATENATE etc. The January 2016 update had some updates around new functions and data entry. Day:  327 of 365, 38 left Tools:  Office 365, Office 2016, Excel Description: Using... Continue Reading →

Day 289 – SharePoint Column Validations on Telephone Numbers

 #Office365Challenge This post will show you how to validate length and use of special characters in a telephone number. Day: 289 of 365, 76 left Tools: Office 365, SharePoint Description: SharePoint Column Validations on Telephone Numbers Audience: All Related Posts: Day... Continue Reading →

Day 282 – Data Cleanup Formulas for SharePoint

#Office365Challenge To conclude my posts around calculated column formulas in SharePoint, I'd like to share my favourites for data cleanup. Day: 282 of 365, 83 left Tools: Office 365, SharePoint Description: Data Cleanup Formulas for SharePoint Audience: All Related Posts: Day 275 –... Continue Reading →

Day 159 Data Clean-up in Excel – Concatenate

#Office365Challenge The next couple of posts will be all about the various functions available in Excel to help you clean data you've received from other sources etc. Today we'll take a look at the Concatenate Formula. Day: 159 of 365,... Continue Reading →

Powered by

Up ↑