How to get a linebreak in Microsoft Excel (Mac & PC)

Posted on by

I’ve only recently come across a keyboard short cut to get a linebreak within a cell using Microsoft Excel which proved to be fairly useful.

A linebreak being carriage return, new line, break, ‘enter’ type of character (now I’m sure someone will correct me and say that they are all different things… but within excel… is it really?) or whatever you want to call it isn’t that hard to do. You can open up notepad/textpad and simply ‘Copy’ and ‘Paste’ the carriage return in excel and it will work, it just isn’t the easiest solution.

So how do you do it? Well depending on if you are using Windows or an Apple machine it is slightly different so find some simple instructions below.

PC \ Windows:

Press ‘Alt‘ + ‘Enter/Return‘

Mac \ Apple:

Press ‘Control‘ + ‘Option/Alt‘ + ‘Enter/Return‘

Server IP Address Change

Posted on by

Just a nice short update. The server tonight will be changing it’s IP address.

Currently it is 203.63.219.26 and is being routed through Melbourne (server is hosted in Sydney). Below is a trace route of the current (soon to be old) IP / route:

traceroute to sporadic-mind.com (203.63.219.26), 64 hops max, 52 byte packets
1 bob2.iinet (10.1.1.1) 1.468 ms 2.784 ms 2.050 ms
2 nexthop.qld.iinet.net.au (203.215.9.250) 15.836 ms 15.942 ms 16.926 ms
3 te7-1.bne-pipe-bdr2.iinet.net.au (203.215.8.22) 20.702 ms 18.010 ms 18.397 ms
4 xe-0-0-3-0.syd-mas-core1.iinet.net.au (203.215.20.108) 29.140 ms 28.665 ms 29.396 ms
5 te7-0-0.bdr1.syd4.internode.on.net (150.101.197.189) 34.272 ms 28.309 ms 28.032 ms
6 * * *
7 aapt-int.sebr2.global-gateway.net.nz (202.50.238.214) 80.532 ms 30.049 ms 29.976 ms
8 te2-4.sglebdist01.aapt.net.au (202.10.14.6) 43.297 ms 45.158 ms 41.198 ms
9 te0-3-4-0.sglebcore01.aapt.net.au (202.10.12.7) 88.395 ms 86.418 ms 43.024 ms
10 te0-0-4-0.mflincore01.aapt.net.au (202.10.10.73) 47.093 ms 44.037 ms 41.943 ms
11 te2-2.mburndist02.aapt.net.au (202.10.12.16) 43.362 ms 85.562 ms 92.111 ms
12 5-1-1.mburninte01.aapt.net.au (203.131.61.33) 43.895 ms 44.605 ms 44.171 ms
13 ns1.rookdns.com (203.174.178.210) 44.644 ms 88.784 ms 74.258 ms
14 * * *
15 sydcp1.optimalforce.com (203.63.219.26) 67.395 ms 57.228 ms 58.656 ms

The IP change will put the server back within a subnet within Sydney so it should tidy things up a bit. This shouldn’t effect anyone (or only briefly), not unless you are using an IP address to connect to Team Speak.

I’ve also taken this opportunity to add a few more icons and images to the channels to try and stop it looking like every other boring server. I’ll update this post when the new IP has been made available.

Update:

The new IP Address of the server is: 27.111.86.240

Also thought I would add the trace route so you can now put everything into context. Huge improvement!

traceroute to sporadic-mind.com (27.111.86.240), 64 hops max, 52 byte packets
1 bob2.iinet (10.1.1.1) 2.093 ms 1.705 ms 3.049 ms
2 nexthop.qld.iinet.net.au (203.215.9.250) 17.979 ms 18.231 ms 18.507 ms
3 te7-1.bne-pipe-bdr1.iinet.net.au (203.215.8.20) 18.033 ms 18.633 ms 24.083 ms
4 xe-0-0-3-0.syd-ult-core1.iinet.net.au (203.215.20.100) 41.944 ms 29.255 ms 29.555 ms
5 as9280.sydney.pipenetworks.com (218.100.2.85) 31.117 ms 32.559 ms 31.031 ms
6 * * *
7 27.111.86.240 (27.111.86.240) 30.250 ms 30.209 ms 34.599 ms

Marshall Soulful Jones performs ‘Touchscreen’

Posted on by

So I’ve discovered a somewhat random youtube channel, and from that channel I ended up discovering a few random videos. Well perhaps the videos on the channel aren’t so random.

The channel: speakeasynyc

Basically the channel is videos of live performances from the Bowery Poetry Club. For more information on the Bowery Poetry Club visit their site: www.bowerypoetrylive.com

The video: I’ve embedded it below, but it is one of many. I thought I would share this one as it makes reference to the digital world we live in today and provokes some thought about how distance from humanity we are becoming.

It is also a different style to poetry which I had in my mind. It is short (a few minutes), entertaining, relevant to today and also engages you on a different level as it is communicated via voice. With out it being conveyed through speach I’m not sure any of the poems would carry as much meaning.

For those who are still not interested, just look at all the popping this guy does during the poem.

Marshall Soulful Jones, part of Team Nuyorican 2011, 2nd place finishers at the National Poetry Slam in Boston, performs “Touchscreen”. The Bowery Poetry Club NY