Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Tag

Data Clean-up

Day 162 Data Clean-up in Excel – TRIM formula

#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 using TRIM to remove unnecessary spaces. Day:... Continue Reading →

Day 161 Data Clean-up in Excel – Left Mid and Right + Search & LEN

#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 Left, Mid and Right Function with... Continue Reading →

Day 160 Data Clean-up in Excel – Left Mid and Right

#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 Left, Mid and Right Function which... 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 →

Up ↑