filmov
tv
Advanced Left, Right and Mid techniques in Excel - Extracting names and postcodes
Показать описание
In this video we'll be showing you some more advanced uses of the functions highlighted in the number 5 spot of our Top 5 Excel Features Series.
In particular, we'll be showing you how to extract the first and last name from a full name (forename and surname) and how to extract the region code from a UK postcode. We'll be using a variety of functions, and breaking our formulae down to show how they work.
----------
If you found this video helpful, please consider liking, commenting or sharing.
For more tips, subscribe to our channel, and visit:
Get more help and advice on Excel, Access or VBA projects:
Visit the Software-Matters website:
Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.
Music:
George Street Shuffle - Kevin MacLeod
In particular, we'll be showing you how to extract the first and last name from a full name (forename and surname) and how to extract the region code from a UK postcode. We'll be using a variety of functions, and breaking our formulae down to show how they work.
----------
If you found this video helpful, please consider liking, commenting or sharing.
For more tips, subscribe to our channel, and visit:
Get more help and advice on Excel, Access or VBA projects:
Visit the Software-Matters website:
Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.
Music:
George Street Shuffle - Kevin MacLeod
0:04:42
0:07:02
0:09:12
0:06:56
0:07:10
0:06:29
0:06:16
0:13:45
0:26:03
0:05:39
0:11:43
0:03:40
0:02:42
0:01:41
0:09:37
0:19:54
0:02:05
0:08:52
0:03:20
0:06:03
0:01:14
0:29:17
0:06:36
0:00:58