#TipoftheWeek – How do I format names or addresses that are a mixture of uppercase and lowercase characters?

I thought I would resurrect these as they are so helpful on a daily basis.

This weeks was inspired by some work I did for a great organisation recently.

How do I format names or addresses that are a mixture of uppercase and lowercase characters?

Column A has randomly formatted text. Just type =proper(Cell Ref) in column B as per the picture below. If you want to keep these as your new column just copy and paste special values 🙂

2

Any questions just ask!

#tipoftheweek – How to Transfer iPhone Contacts to Outlook via iCloud

This weeks tip was inspired by a conversation in a networking group.

If like me you use an iPhone to pretty much run the admin side of your business until you can get to your laptop/pc you may want to sync your contacts and calendars with Outlook.

Here’s how:

How to Transfer iPhone Contacts to Outlook via iCloud

Download and install iCloud on your computer

https://support.apple.com/en-gb/HT204283

Run it and sign into your iCloud account

Tick Contacts, Calendars, & Tasks With Outlook & Apply

Make sure to apply the following settings on your phone to enable a two way sync

On your iPhone go to Settings > Passwords & Accounts > iCloud. If prompted sign into your iCloud account and make sure the Contacts and Calendars are showing as green (if not select the ‘slider’ until it is green)

Your iPhone may ask you what you would like to do with existing local contacts, calendars etc. on your iPhone, if it does select Keep on My iPhone in order for the sync to take place

Go back a screen and select Fetch New Data and make sure this is showing as green (if not select the ‘slider’ until it is green)

And voilĂ  your contacts and calendar are synced from your iPhone to your Outlook!

#TipoftheWeek – Use the FREE Sharepoint Migration tool!

See below review on the newest version!
 

#TipoftheWeek – How to stop Facebook videos from playing in the App

Firstly open up the app then click on the 3 horizontal lines in the bottom right hand corner.

Scroll down until you see ‘Settings & Privacy’ and select it.

Then select ‘Settings’

IMG_0705

Scroll down until you reach the ‘Media and contacts’ section and select ‘Videos and photos’.

IMG_0703

 

Under ‘Auto-play’ select ‘Never Auto-play Videos’.

IMG_0704

Any questions just ask 🙂