Archive for February, 2009
Does exactly what it says on the tin; just the posts that relate to the above...
Mixd Excels
Tuesday, February 24th, 2009
As an organisation, Mixd is always keen to help others… and today is no exception. Based on the results of important scientific research (Bob closely watching Phil this morning and chuckling), this could save you from days of stress and sleepless nights of worry.
So here it is, the simple process of merging 2 (two) columns of data into 1 (one) using the Microsoft product ‘Excel’. Step one can be omitted as you see fit, but can be fun.
Step One
Watch colleague pull own hair out for up to 90 minutes (longer than this is just not on), trying to work out how to do it.
Step Two
Assuming the data to be merged sits in columns A and B, select column C and choose Insert > Column to insert a new (blank) column C.
Step Three
Assuming that data starts in row 2 (allowing for your headings), whack one of the following formulae into cell C2.
To hyphenate the merged data
=A2&”-”&B2
To merge with a space between the data
=A2&” “&B2
Step Four
Copy the formula as far down column C as needed (by dragging the bottom right corner of the C2 cell).
Step Five (the magic bit!)
Next, select the entire column C; choose Edit > Copy; then Edit > Paste Special; then Values and OK. This pastes the cell contents (not the formulae) back into column C.
Step Six
You can now simply delete columns A and B; easy.
Please send thank you cards to the usual address.
Mixd accepts no liability if this doesn’t work for you; apologies.
Mixd creative web design – Harrogate?
Thursday, February 12th, 2009
When Mixd opened its doors in Harrogate for the first time at the start of 2009, it heralded the arrival of a new creative force in the North Yorkshire spa town. Mixd is an exciting young business which started in Northallerton in 2004; but why the move to Harrogate?
Partner, Phil Shackleton, says, “We’re delighted to have made this move. Harrogate is an ideal location to service our existing client base plus the town’s travel and leisure connections are a great fit with our growing specialism in this sector.” Phil continues, “We’re expecting this move to provide a great springboard for the next stage of Mixd’s growth. Plus our firm desire to be a ‘green’ business is greatly helped by the fact that most of the Mixd team are now able to cycle to work every morning!”
There you have it. Now you know.
New year, new office and new website! Whatever next?
Tuesday, February 10th, 2009
New year, new you… so they say. Well, here at Mixd, we’ve really gone to town on all things new. Whilst we can’t really take any credit for the new year, we must say how delighted we are with both our new physical home (a stone built period property set in a beautiful, leafy Harrogate street) and our new virtual home (on the world wide web which, in our mind’s eye, is leafy and beautiful too).
We throw open an invitation for you to visit both whenever you like… which one you visit is up to you. The office is but a stone’s throw* away from the Harrogate International Conference Centre, the focal point of this lovely town, and you’ll find a warm welcome Monday to Friday, 9 ’til 5.30. You can of course, visit the website wherever you find internet access, 24 hours a day… the only drawback being you’ll have to make your own brew (although anyone who has tasted one of Phil’s coffees will probably see this as very much a positive).
*please don’t throw stones, it’s dangerous and can have someone’s eye out (it’s even worse if you live in a glass house, so we’re told).
Follow Mixd on Twitter
Monday, February 2nd, 2009
If you just can’t get enough of us here, we’re also now broadcasting out into the Twittersphere. If you’re not in the know, Twitter is a microblogging service that makes it easy to keep up with your favourite people (hopefully us) on multiple networks and devices. Consider it Mixd’s ‘breaking news’… but not always as serious as news type stuff.