Tom’s Tutorials For Excel: Displaying a Column’s Width
You can display a column’s width manually, or in a cell with a User-Defined Function. The first picture shows that when you press and hold your left mouse button between column headers, a column’s width appears in a tooltip.
…
Tom’s Tutorials For Excel: Returning a Formula’s Arguments
I saw a question last year on one of the Excel newsgroups, asking for a way to return a formula’s arguments. I wondered, as you probably are, why this person wanted such a thing.
Still, I was intrigued at the question,
…
Tom’s Tutorials For Excel: How to Show Your Workbook’s Name in a Cell
Here are a few ways to show your workbook’s name in a cell, example, YourWorkbookName.xls.
Formula (goes on one line but broken into 2 lines for browser readability)
=MID(CELL(“filename”,A1),FIND(“[“,CELL(“filename”,A1))+1,FIND(“]”,
…
Tom’s Tutorials for Excel: Sum and Count Cells By Color
To sum, count, or perform a mathematical operation on a range of colored cells, you will need VBA. Excel does not have a built-in native worksheet function to mathematically evaluate contents of colored cells, such as summing the numbers in all red-colored cells.
…
Tom’s Tutorials for Excel: Separate numbers and letters from alphanumeric string.
You sometimes need to extract only numbers, or only letters, from an alphanumeric string.
For example if you have this:
HTRDFR9745 and you only want 9745
or you have
65UYDKWHDHSDUK and you only want 65
or trickier yet you have a mix like this:
FJ7R9yW5PXQ and you only want 795
Or,
…
Tom’s Tutorials for Excel: 3 methods to display sheet tab name in a cell
“How do you display a sheet tab name in a cell?” is one of the questions Tom Urtis is most frequently asked.
Here you have 3 useful answers
Method 1 – by formula,
…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
