Pixel Excel Drawing
This guy has nothing to stop him
Month: August 2022
Cuts string of list of items
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using formulas only.
Excel @ before function names in formulas
Looks like there is a change coming. Excel started adding the symbol @ to some formulas, not sure why only those, but we are waiting to start using this new feature.
Return 12 values in one number
A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for […]
Cells with additional spaces
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)
Comments versus Notes
It is official and looks better now, I know it might be confusing, but I liked it so far Excel now has “Comments”, the classic Comments are now called “Notes” I used Notes a lot, mainly to remind me of certain expectations of some cells, or guide the user to some additional info about some […]