When Text-to-Columns Fails

A functional Van der Merwe story In a column of full names containing first, middle and last names, Excel’s Text-To-Columnsfunction fails with last names like “van der Merwe”. To get around this, using Names Manager, we’ll create our own text functions standing on the broad shoulders of some text functions already available in Excel: FIND, [...]

By | 2017-05-19T07:44:19+00:00 May 11th, 2016|Blog, Excel Articles|0 Comments

Excel Tip: Forms & Protection

Forms & Protection Sometimes we need to create form-like sheets in a workbook, for example where user input is wanted. Presenting a plain grid is bland. Usually cell colouring results in a more attractive form, e.g. Here is an approach to creating a sheet that behaves like a form, using cell protection: Create a form [...]

By | 2017-05-19T07:44:46+00:00 September 30th, 2015|Excel Articles|0 Comments

Excel: Three new functions in 2013

Excel 2013: three new functions DAYS() Date arithmetic is nothing new in Excel, but this function is new to Excel 2013. Previously one had to use a formula like “=B1-A1” where B1 would contain the later date, A1 the earlier date. Typing “=DAYS(“ in a cell, you are prompted with “end_date,start_date”), for the formula =DAYS(B1;A1) [...]

By | 2017-05-19T07:44:58+00:00 July 29th, 2015|Excel Articles|0 Comments