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!