Search results 22

Sorted from new to old.

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

2025May22

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

nyan bars

Progress bars, animated, customized, neat and new From

2019Aug1

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

Simple Captcha

Sometimes the simplest methods is the most powerful. That is what I said

2018Dec27

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31

1 2