## Middle name + 1st name

Get the initial (middle name) from a triple name in a cell.C4 The cell contains the triple name separated with spaces.=LEFT(C4,1) & "." & MID(C4,...

Skip to content
##
XLf(x)s

#
Category: Basic Math

##
Middle name + 1st name

##
Walking Columns

##
Unix DateTime Number

##
Get 3rd Wednesday of month

##
Repeated Offset

##
6174 Kaprekar’s constant

##
0% interest promotion

Excel functions and formulas

Get the initial (middle name) from a triple name in a cell.C4 The cell contains the triple name separated with spaces.=LEFT(C4,1) & "." & MID(C4,...

An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting,...

Convert Date/time number from regular number to Unix DateTime Number....

This was an interesting request. Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions. So, sharing here...

I needed to have an offset of columns to be repeated every 12 months. This is part of a project, we needed to calculate the...

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads...

The past few months, I established a formula to help me determine if certain credit card promotion makes sense or not. This helped me a...