EXCEL: Set Cell Value as Tab Name
In order for this formula to work you need to make sure the workbook has been saved; otherwise, the cell will result in an error.
FORMULA:=MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255)VIDEO TUTORIAL:
let's get random
Happily married, proud parent, systems analyst, sql server enthusiast, command-line and vbs junkie, graphic/video noob and an overall good guy!
VP of the Arizona chapter for PASS Arizona PASS
SQL Saturday - Phoenix Event Organizer
Filed under
excel
=MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255)VIDEO TUTORIAL:
EXCEL: SQL Generator...
In my line of work I write T-SQL statements quite a bit so having to write them over and over again can be tiresome. Here is tip that can help you generate T-SQL insert statements very quickly, especially if you seem to use the same tables over and over again. This is my first attempt using another tutorial software so bare with me.
Enjoy!
Posted by Samson Loo
Comments [0]
EXCEL: Count character length...
If you ever need to find the total amount of characters including the spaces between the words use this easy tip.
Posted by Samson Loo
Comments [0]
EXCEL: Repeat text...
Another quick formula that makes duplicating text easy.
Posted by Samson Loo
Comments [0]
EXCEL: All Upper Case...
Once again if you need to change all the text to upper case here is a quick solution.
Enjoy!
Filed under //
all upper case
excel
Posted by Samson Loo
Comments [0]
EXCEL: Lower case...
Just in the event you need to change the text from capital to lower case.
Filed under //
excel
lower case
Posted by Samson Loo
Comments [0]
EXCEL: First Initial Last Name...
I just wanted to post a simple and quick video tutorial on how to Generate a First Initial Last Name from two columns Fristname and Lastname within Excel.
Enjoy!
Filed under //
excel
first inital last name
Posted by Samson Loo
Comments [0]
Highlight every other row in EXCEL...
You are working on an excel spreadsheet that contains literally hundreds to thousands of rows and instead of manually changing the row color line by line, you want it done automagically!
Before
After
Trick number 1.
Select one of the cells that contain data. Then press CTRL+A. I will choose cell 4D. This will highlight all the cells with data in it. If you have breaks or gaps in your spreadsheet this will not work. It only works on clusters of data. Look at the example below!
Trick number 2.
While the needed porition of the spreadsheet is highlighted, click on "Format" from the file menu. Select "Conditional Formatting..."
Change the "Condition 1" dropdown to "Formula Is" and type in
=MOD(ROW(),2)=0, then click "Format"
NOTE:
(The 0 indicates to skip the first row, change it 1 to include the first row. The number 2 in this formula indicates that every other row needs to be highlighted, so if you change this value to the number 3 then every third row will be highlighted, so-on and so forth. Also if you want to highlight columns simply change the word from ROW() to COLUMN() and now the columns will be highlighted instead. However, if you want both then add another formula!)
Click on the "Patterns" tab
Select the lightest shade of Gray and click ok
Then click ok to close the Condional Formatting dialog screen...
...that is it, there you have it. Every other row is now highlighted!
Posted by Samson Loo
Comments [0]
Comments [0]