Categories
Excel 2013

How To Replace Dashes With Periods in Excel

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.

Categories
Subscribers Excel 2013

Subscribers: How To Sum Time Greater Than 24 Hours In Excel

There is a quick and easy method to sum time past 24 hours and all that is necessary is changing the format of the cell. Below is a list of start and finish work hours. There is also a column that calculates the total number of hours worked. We need to find the total number […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Carol's Ramblings

Carol’s Ramblings…

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…

Categories
Subscribers Word 2013

Subscribers: How to Use Quick Tables in Word

Have you ever heard of Quick Tables?  I ask because most of my clients have never heard of this! So I thought it high time, that I told folks about it. Quick Tables has many tools and options and they can be quickly and easily placed into your document. They are already formatted with styles […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2013

Subscribers: How to Use Different Colors When Using Track Changes in Word

In an office setting there could be a number of colleagues collaborating on a single document and of course they use Track Changes to note edits made in that document. So suppose one person made corrections in a document with Track Changes turned on, so their changes were in one color. Thereafter, another colleague reviewed […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2016

Subscribers: Footnotes Within Footnotes in Word

Footnotes are used  in many kinds of documents. In some documents you may actually need footnotes within footnotes, (i.e., a footnote within a footnote) so that a footnote can be footnoted, using a  "sub footnote" that will appear in the regular flow of the main footnotes. Word is very good at creating footnotes, using either […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2013

Use the Format Painter Feature in Word!

You all know I am the queen of saving time and keystrokes and this little workhorse feature does a lot of that! To quickly format your parts of your document like other sections, use the Format Painter! It is on the Home tab of your Ribbon. Simply select the formatting you would like to place […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2016

Subscribers: How to Use Unique Serial Numbers in Your Word Documents

Sometimes you may find a need for unique serial number in your documents, and let's say your serial numbers have to be specific and non-sequential. (i.e., C3526, the next one Y1317 , Y1324) If you know what serial numbers you need for your particular use, the quickest method to use for this situation is the […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Word 2016

How to Back Up Your AutoText Entries in Word

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!