top of page

Conversions with Excel

Removing extra spaces in postcodes

Counting how many cells have text

Xlookup - looking up the price from price list

Arranging text with the proper capital and small letters

The unique formula, removes duplicates and keeps unique values only

Joining names and surnames with space in between

Calculating your age using Excel

Xlookup - looking up more than 1 field at once

Xlookup - where price varies per quantity ordered

Creating a drop down list based on a pre-determined and existing list

Using flashfill to split cells

Creating drop down list on the go

bottom of page