Sincere Thanks

I appreciate the many people who sent me a "happy birthday" note after last week's issue. Your kindness in doing so was refreshing, to say the least.

I hope that your weekend is going well and that you enjoy the tips in this week's newsletter.


ExcelTips (ribbon) for 19 June 2021

Cell formatting
Specifying Font Color in a Formula

Do you need to change text color based on the result of a formula? This tip provides a couple of ways you can accomplish the task without using conditional formatting.

Read this tip »

(Thanks to Patrick Sedgwick, Jo Osment, Fred Potter, Steve Aprahamian, Dennis Riddle, Tomek Dluzniewski, Andrija Vrcan, Ron Solecki, Joe Smith, Peter Dillon, Michael Avidan (MVP), Ryszard Raciborski, Bob Beechey, and Wayne Edmondson for contributing to this tip.)

Replacing Dashes with Periods

Replacing one character in a text value with another character is easy. All you need to do is use the SUBSTITUTE function, as illustrated in this tip.

Read this tip »

Lookup Exactly the Data You Want

Excel's lookup functions are easily the most powerful worksheet functions you can use. Master these seven functions you'll never again view a worksheet full of data in the same way. The power these functions provide you is anything but small. Take your first step today!

Drawing Simple Objects

Want to draw a few simple shapes or lines on your worksheet? It really is simple; here's how to do it.

Read this tip »

Excel can calculate date in lightening time
Grabbing a User's Name from Excel

One of the settings you can make in Excel is to specify a user's name. This name is accessible through macros, and can therefore be used within your worksheets. This tip examines the simplest method of accessing the user's name.

Read this tip »

Creating a Workbook Clone

If you are afraid of messing up a workbook, consider doing your work on a clone of the workbook. Excel provides an easy way to create the clone.

Read this tip »

Online and web
Getting Rid of All Hyperlinks

Need to get rid of all the hyperlinks in a worksheet? It's easy when you use this single-line macro.

Read this tip »


Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Importing Very, Very Large CSVs into Excel

I have a CSV file I need to import into Excel. Normally this wouldn't be a problem, but this CSV file has well over a million rows in it. Is there any way to get such a huge file into Excel?
—Damodar Kanuri (provide an answer for this Help Wanted question)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450