This week’s email newsletter article is:
- Text Manipulation in Excel – A Practical Example
After my recent article Using Excel to Manipulate Text, I received an email from subscriber Noel asking for help. He was trying to use Excel for some manipulation of text, having trouble with numbers converting:
Gidday from NZ (again) Terry
I liked the article "Using Excel to Manipulate Text", and wonder whether you might be able to assist me in a little exercise. I work for a training organisation, and with each new class intake I need to
This Week Online — Blast From The Past
A Look at Articles from Past Newsletters
What does it mean to trust a network?
When you connect your computer to a network, at least one dialog box should open warning you if you’ve never connected to that network before. If you’re running Windows 7 or later, you should get two separate queries.
The first dialog box to open should be from your firewall program. If it’s doing its job, it should identify that the IP addresses on the network and/or the MAC address of the switch or router to which it is connected, are different than it has seen before.[…]
Windows 7 has a number of troubleshooting tools built into it, which can be real help when things are not working correctly.
The tools can be accessed in two ways. You can click on the Start button (the Windows Orb) > Control Panel > System and Security. Then, under the Action Center heading, click on Troubleshoot common computer problems.
Alternatively, you can click on Start, and type troubleshooting in the search box, and select the Troubleshooting entry it finds. […]
One of the nice features of the iPhone is Apple’s proprietary iMessage system. When you try to send a text to another iPhone, it will use Apple’s iMessage system instead of the usual pay-per-message SMS text message system.
Which did your message use? Easy to know — the background color of an iMessage is blue, while a SMS text message is green.
Well, it turns out that there’s a fly in the ointment, at least for iPhone users who switch to other phone types […]
One of the neat things that you can do with Excel is to use it to manipulate text.
If you have a rows of similar data, all of which need to be manipulated in the same way, Excel excels in letting you extract, add, manipulate, and generally modify the text. There are a number of Excel functions that are designed for text manipulation. […]