Pasting tables – line breaks in Word and Excel

 Computers, Technology, Work  No Responses »
Aug 062012
 

I wanted to copy a table in Microsoft Word 2010, and paste it into excel – however there was the small issue of some of the cells containing multiple lines of content, with lines separated by line breaks. when these were copied into excel, each line ended up in a separate cell of its own, not what I wanted.

I now know that some special characters can be entered into Microsoft Word find and replace boxes for example “^p” is the same as the line break. however these codes cannot be used in excel. that would be far too easy. No, there is a different code in excel which happens to be “ALT+010″ so now there is a few stages to the process

  1. firstly select the table and find “^p” and replace with something that is not used like “@@”
  2. copy table and paste into excel
  3. now find the “@@” and replace with “ALT+010″ which looks like a “.” but turns into line breaks within the cells.
  4. done.

Now I might be able to get done what I was planning.

Chasing around the User Interface

 Computers  No Responses »
Apr 292012
 

Microsoft Office 2007 was quite a departure from previous versions, huge changes to the user interface, and the removal of the old menu structure, its all bout the Ribbon now. The same changes happened to Microsoft Outlook in Office 2010. I would guess that it is a lot easier for new users to get work done, and indeed I have found that tasks (like saving as pdf) now take less clicks, but some of the more advanced uses are harder to find, or maybe its just because you used to know where something was and cannot find it now.

I have been confused for a while as to where the outline display of tables with no borders has gone. Yes, I know I am using print layout, but word still used to show the outline of a table with no borders, useful when documents are using tables for layout. My most recent attempts of finding an answer via Google have found the answer.

1) move curser into table, 2) select "Layout" from within "Tablke Tools" on the ribbon, 3) Select "Show Gridlines"

and so the table gridlines will be shown!

Microsoft Money Sunset – Autorun.inf problem

 Computers, Technology  No Responses »
Apr 212012
 

I am still migrating to a new laptop.

I wanted to install Microsoft Money Sunset on the laptop, but the download from microsostf would not run. My solution is as follows

  1. Unzip the downloaded file using 7-zip
  2. inside the extracted directory run “mnyinstall.exe”
  3. when it suggests you stop and run “setup.exe” instead, click “no”

Thanks to the comment from a forum

So I unpacked the archive using 7-zip for example to a new folder. In the folder I clicked on mnyinst.exe instead of setup. It gives a warning and suggests you run setup.exe, but I clicked no to that and it continued installing without any problems.

 Posted by at 3:39 pm

Decorating

 Computers  No Responses »
Oct 232011
 

This might be my revised website. New choice of theme, and the upgraded wordpress 3.2.1. I think it’s time to start removing pugins (at least on the front page) and clean it up a little.

then i want to start looking at my other weblog….

However i still don’t know why my website, and hosting provider cannot be accessed easilly from home, it is really slow (it appears that i can only transfer data at 8kB) I have had to be a little sneaky to finally get access to backup and then upgrade the website.

 Posted by at 9:42 pm

Twittering via SMS

 Computers, Sailing, Site News  1 Response »
Nov 032010
 

I have for a few years been posting to twitter via SMS, using +447624801423. Having just got back from a voyage aboard Stavros S Niarchos, i looked at Facebook, which should have status updates from twitter, and nothing had appeared. Odd.

It turns out twitter now uses the number 07624800379 – i am not going to use the short code as that costs me money, the long number comes out of my text bundle….

So no-one heard about the fun i was having whilst away, clearing out the fore peak store. Shame.

 Posted by at 11:02 am

Book Shopping

 Computers, Money Saving  1 Response »
Jan 012010
 

Amazon is not the only place to buy books from.

Whilst google product search allows me to easily find prices for products at loads of places, shopping for books used to be a bit of a grind.

For the last couple of years, when i am buying books I have been using Book Brain to search for the cheapest provider – and with many places now not charging for delivery, its almost a case of just buying each individual items from the cheapest place.

Where do you fit?

 Computers  No Responses »
Dec 312009
 

The following image is provided to clarify the difference between geek, nerd, dweeb and dork.

Social Order

Yes, I would rather you call me “Geek” than any of the other options.

(Now I think my wordpress is updated, its time to clear out some drafts…)

 Posted by at 6:22 pm

WordPress 2.9 (Again)

 Computers, Site News  No Responses »
Dec 312009
 

earlier I said

I have done my almost annual update of wordpress. On this occasion, i backed up, deactivated all plugins and used the auto update. i then tried to reactivate all plugins, this muked up something behind the scenes, so i disabbled them all by renaming the plugins directory! when i activateded them one by one, and updated a few it all worked.

Oh, and i have learned that i have the “other” ad rotator plugin. but that is fixed now too.

If anyone sees anything that is broken, please do let me know!

and then it all went horribly wrong, so i had to go back to my Database backup from this morning.

“Now Reading” plugin appears to be broken in WordPress 2.9, so I am now using “Now Reading Reloaded”

so i think it all works now. however do let me know if you think other wise!

 Older Entries

Switch to our mobile site