Breaking text up into words in excel formula – 3rd,4th etc

These formulas work well and are easy to adapt for any word in a string of text  – just change the SUBSTITUTE number through out the fomula to 1 less than the word you are looking for. The IFERROR returns a blank but it can be useful to return a character something like “^” instead for lookups.

4th
=IFERROR(TRIM(MID(MID(SUBSTITUTE(A23,” “,”^”,3),FIND(“^”,SUBSTITUTE(A23,” “,”^”,3))+1,256),1,FIND(” “,MID(SUBSTITUTE(A23&” “,” “,”^”,3),FIND(“^”,SUBSTITUTE(A23,” “,”^”,3))+1,256)))),””)

3rd
=IFERROR(TRIM(MID(MID(SUBSTITUTE(A23,” “,”^”,2),FIND(“^”,SUBSTITUTE(A23,” “,”^”,2))+1,256),1,FIND(” “,MID(SUBSTITUTE(A23&” “,” “,”^”,2),FIND(“^”,SUBSTITUTE(A23,” “,”^”,2))+1,256)))),””)

2nd
=IFERROR(TRIM(MID(MID(SUBSTITUTE(A23,” “,”^”,1),FIND(“^”,SUBSTITUTE(A23,” “,”^”,1))+1,256),1,FIND(” “,MID(SUBSTITUTE(A23&” “,” “,”^”,1),FIND(“^”,SUBSTITUTE(A23,” “,”^”,1))+1,256)))),””)

1st
=TRIM(MID(A23,1,FIND(” “,A23&” “)))

Tips on Google webmaster tools URL exclusion and inclusion

Google allows you, as a site owner, to exclude URLs that have got into their index

  1. By mistake
  2. They are part of an old structure
  3. They are causing duplicate content

Probably as important Google allows you to cancel these instructions as well

Blocking a URL from Google

You need to use webmaster tools

https://www.google.com/webmasters/tools and select your site

On the left menu select “Remove URLs”

Google Index URL removal

There you can request to remove a file or whole directory.

If you choose to remove a directory it is very important to remember to put the trailing “/” on the end of the URL

i.e. http://www.mywebsite.com/tools  is different from http://www.mywebsite.com/tools/

The first will remove all directories that start with “tools” the second will remove just “tools”

Unblocking a URL from Google

If, like me, you did a http://www.mywebsite.com/tools to watch your site disappear in a stroke there is a remedy

Select to show “All”

Where to file URL exclusions

If the block is still active you can elect to Cancel the block

I hope this helps – it did for me.

Creating a graphic skin for your website

Want to create a skin around your website to make it more appealing – a little like this?

homepage

Simple

Create a graphic like this where the centre is empty

This is two similar strips 140px wide and 700px deep that are placed either side of a 1200px centre. I have added a shadow to the left for effect.
Skin background

Add this to your body tag using this style

style=”background-image: url(bg.png); background-attachment: fixed; cursor: pointer; background-position: 50% 0%; background-repeat: no-repeat no-repeat;”

Your website centre will scroll within this skin and look really good.

Social Media Spam Up 355% – “Like-jacking,” social bots, fake accounts

From January to June of 2013, there was a 355% growth of spam to the typical social media account, according to a recent study by Nexgate.

Simple text- and link-based posts were found to be the most popular types of social media spam, while “Like-jacking,” social bots, fake accounts, and “spammy apps” were the most prevalent forms of distribution.

Social Media – Social Media Spam Up 355% : MarketingProfs Article.

Social media – failure is an essential ingredient of success

No one is immune from failure on Social Media – the great thing is to learn from failures and to communicate that to you colleagues.

A lot of Social Media is about experimenting, measuring, adapting and moving on. Usually there is no one solution just some basic rules.

4 things I learned about social media from 4 years at SmartBrief SmartBlogs.

Facebook hashtags have little effect on engagement – Social Marketing – BizReport

Hashtags are a powerful discovery tool on Twitter but, according to new research, they have little impact on engagement within the Facebook environment.

Research from social media analytics firm Simply Measured has found that, while 20% of top brands’ Facebook posts now include hashtags, there is no evidence they are influencing engagement. In fact, according to the research, posts with hashtags perform just as well as those without.

Facebook hashtags have little effect on engagement – Social Marketing – BizReport.

Using Hashtags – how to build more conversations & buzz around your business

Now that Facebook has now brought in hashtags they are basically across all social media channels – Twitter, Google+, Pinterest, Tumblr, and Instagram. So there are some tips on how and why to use them in your posts.
Make sure you hashtag is the hashtag you wanted!
Hashtags start with a #, is alphanumeric so no spaces – the tag stops at the first space or punctuation.
  • You can have upper and lower cases i.e. #MyBestTag. I think this makes the tag more readable.
  • You can use the underscore “_” for spaces i.e. #My_Best_Tag. By using the underscore you are making the tag longer.
Keep your hashtag short 
Make  it easy for users to remember your hashtag – including the spelling! Stats show that concise hashtags are more effective than long ones especially as you will want to keep them consistent across all channels. With Twitter restricted to 140 characters your hashtags need to be short
Unique hashtag names
You need to differentiate yourself from your competitors. Unless your joining specific conversations avoid general hashtags i.e. #jobs or #hot. These sort of hashtags are too broad to relate conversations directly to your business.
Promote your hashtag
If you have a range of hashtags you use then promote it. You will see broadcasters do this so why shouldn’t you. Add them to your promotional material, website, blog etc.
Associate your hashtag to competitions (you will see this on Instagram all the time), events, feedback, comment etc. Anything that allows people to engage with you one way or another.
Do not clutter your hashtags
There is a lot of discussion on how many hashtags you can use in a post, we recommend no more that 3. The more you use the more confusing it can become and increases the potential of diluting the post.

What does Google Bounce Rate mean?

Many of my clients puzzle over the bounce rate quite often for the wrong reason.

The definition of a bounce

If a user lands on a page – i.e. it’s the first page they see on you website – and then leaves to a different website; presses the back button or just does nothing, they are deemed to have bounced.

The definition of an exit

If a user lands on a page and came from another page within your website and then leaves to a different website, they are deemed to have exited.

bounce

What does this mean?

Many of the clients I work with probably want a high bounce because the searcher has found what they are looking for an left the page.

  • A phone number
  • An opening time
  • An email address

So it depends a lot on the nature and objective of the website.

I have one client who publishes articles to get the user to his site so that they will move onto other parts – there a high bounce rate is bad news.

So if for certain pages your bounce and exit rate are high then there maybe something wrong – unless that page is a destination page then it’s a result.

See Kissmetic Bounce Rate Demystified really good infographic

Email still tops social media for online marketing

Over the past couple of years, in a world drenched with talk about the communicative power of social networks, one can be forgiven for thinking email is as passe as phone booths. Yet, a new study finds that email continues to trump social media channels for reaching online customers and markets.

Good old-fashioned email — a medium tainted and polluted with all manner of online pharmacy scams, Nigerian oil fortune hoaxes, and phishing galore; considered a daily time sink — is still providing the biggest bang for the buck for organizations seeking to reach and maintain high-value customers.  That’s the finding of a new study from Custora, which estimates that customer acquisition via email has quadrupled over the last four years:

See full article Email still tops social media for online marketing, study says | SmartPlanet.

also see

E-Commerce Customer Acquisition Snapshot.

via Email still tops social media for online marketing.