Suppose you need to change the appearance of the data in your worksheet. For instance, you may want to replace dashes in a text string with periods. For example, if you have a phone number formatted as 235-456-7890 you may want to change it to 235.456.7890.
This is very easy to do using the SUBSTITUTE function:
=SUBSTITUTE(A3,”-“,”.”)
The end result is that your dashes appearing in the string in cell A3 are replaced with periods.
Told you it was easy!
Thank you to Allen Wyatt.
Here I thought Spring was just about here! I came home from work one evening and lo and behold, I could hear the peepers singing down at the creek and what a symphony it was! Music to my ears! And then I spotted the leaf buds on the trees, and the temperatures started fluctuating between cold and warm and cold and warmer. Then I found that my one little Daffodil that sits in the woods just outside my window had burst through the ground and had three buds on it! (I swear this year I am going to plan a lot more!) Not only that, but the Hyacinths pushed through to meet the sunshine as well! Well that’s it I thought, Spring is definitely here!
And then my bubble was burst… The temps are down in the twenties and thirties again and we are right now under a winter storm warning and have been told that we will receive between 14 and 18 inches of snow! Well, I ran out and put a bucket over my little daffodil and hopefully it will not be ruined. Brrr….I hate being cold! I am so longing for springtime and sunshine! Hopefully this will be winter’s last hurrah and warmer climes are on the way.
But just in case winter is hanging on for a bit, please remember your neighbors, the homeless and those less fortunate than yourself. Do what you can to help them through the last of winter.
I hope you enjoy the snowfall if you are getting some of it and I hope you enjoy this newsletter as well.
Lastly, I would like to wish you all a Happy St. Patrick’s Day! I like to think we are all a tad Irish on March 17th! Me, I’m half Irish and half Scottish – a grand mixture!!
Until next time…
AutoText in Word saves tons of time and keystrokes for you. It allows you to assign text or graphics to a word and then replace that word with the text or graphics of your choice. If you have been using Word for as long as I have, you have most likely amassed quite a few AutoText entries for things like signature blocks in letters and pleadings, boilerplate text (i.e. in the above-referenced matter), and difficult words that you often misspell.
Assuming you do have many AutoText entries, you might wonder just how you can back them up so they can be moved to a different computer. It is actually pretty easy to do. All that is required is for you to back up your template files, which where your AutoText entries are stored.
If I had to guess I would say that most of your commonly used AutoText entries are in your Normal template file, so backing up this file will help you retain the majority of your information. Many folks who use Word, however, also store AutoText entries in other template files.
To be on the safe side, you can search Windows to locate all of the files on your system that use either the DOTX or DOTM extension. You can then quickly copy them to a backup medium, (i.e., CD-ROM, flash drive, another disk location).
There you go – another problem quickly resolved!
